Difference between revisions of "Excel"
Jump to navigation
Jump to search
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
= Excel = | = Excel = | ||
== Removing the .jpg 3 cells then concat them== | == Removing the .jpg in 3 cells then concat them== | ||
=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) | ||
| Line 8: | Line 8: | ||
{| class="wikitable" | {| class="wikitable" | ||
|one.jpg || two.jpg || three.jpg || one, two, three | |one.jpg || two.jpg || three.jpg || one, two, three | ||
| | |} | ||
== Suppressing errors if you have a blank line == | |||
=IFERROR(LEFT(A1,LEN(A1)-4),"")&","&IFERROR(LEFT(B1,LEN(B1)-4),"")& ","&IFERROR(LEFT(C1,LEN(C1)-4),"") | |||
==Create a sequence of 20 rows== | |||
= "NO." & SEQUENCE(20) | |||
Latest revision as of 16:13, 9 August 2022
Excel
Removing the .jpg in 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 |
Suppressing errors if you have a blank line
=IFERROR(LEFT(A1,LEN(A1)-4),"")&","&IFERROR(LEFT(B1,LEN(B1)-4),"")& ","&IFERROR(LEFT(C1,LEN(C1)-4),"")
Create a sequence of 20 rows
= "NO." & SEQUENCE(20)