Excel
Jump to navigation
Jump to search
Excel
Removing the .jpg 3 cells then concat them
=LEFT(A1,LEN(A1)-4)&","& LEFT(B1,LEN(B1)-4)& ","&LEFT(C1,LEN(C1)-4)
- Results
one.jpg | two.jpg | three.jpg | one, two, three
|