Image enum buttons, returns "photo.png" remove ".png"?

spinning my wheels trying to first create dynamic custom image enum buttons lists… i would like to concatenate two colunms, “image1.png”, and “image2.png” return value would be “image1 image2”
probably overthinking the solution also i have not logged many hours in computer skills…
thanks in advanced

Solved Solved
1 3 402
1 ACCEPTED SOLUTION

@Jonny_Walker
May this help?

INDEX(SPLIT([ImageColumn1],"."),1)&" "&INDEX(SPLIT([ImageColumn2],"."),1)

View solution in original post

3 REPLIES 3

@Jonny_Walker
May this help?

INDEX(SPLIT([ImageColumn1],"."),1)&" "&INDEX(SPLIT([ImageColumn2],"."),1)

success…TRIM(RIGHT([column1], 4)),TRIM(RIGHT([column2], 4))… half would work but couldnt glue em together

wow, idk how you did that but you saved me from pulling more hair out… i thank yee very kindly,
first time posting
response time was excellent
thank you thank you

You’re welcome

Top Labels in this Space