Excel

From rbachwiki
Revision as of 16:13, 9 August 2022 by Bacchas (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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)