Difference between revisions of "Excel"
Jump to navigation
Jump to search
(Created page with "= Excel = == Removing the .jpg 3 cells then concat them== =LEFT(A1,LEN(A1)-4)&","& LEFT(B1,LEN(B1)-4)& ","&LEFT(C1,LEN(C1)-4)") |
|||
| Line 4: | Line 4: | ||
=LEFT(A1,LEN(A1)-4)&","& LEFT(B1,LEN(B1)-4)& ","&LEFT(C1,LEN(C1)-4) | =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 | |||
|} | |||
Revision as of 15:40, 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 |