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 405
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