Difference between revisions of "Excel"
Jump to navigation
Jump to search
| Line 9: | Line 9: | ||
{| | {| | ||
|- | |- | ||
|one.jpg||two.jpg||three.jpg||one, two, three | |one.jpg || two.jpg || three.jpg || one, two, three | ||
|- | |||
|} | |} | ||
Revision as of 15:43, 9 August 2022
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 |