CODEWITHSUNDEEP
excelexcel-formula
chris
chris

Reputation: 971

Excel formula to split cell text based on char count

Currently around 500 chars in my cell and i would like to split anything over 255 chars into the next cell. The below just duplicates the cell value if over 255 chars and does not split it.

=IF(LEN(A1)>255,A1,"")

Don't want to use the UI split text feature as i need to run multiple times and its so time consuming.

Appreciate any assistance.

Cheers~

Upvotes: 0

Views: 18855

Answers (1)

ashleedawg
ashleedawg

Reputation: 21639

If the cell with you text is A1, then:

  • ...in the cell that you want the first 255 characters, you'd use formula:

    =LEFT(A1,255)

  • ...in the cell that you want the remaining characters, if any, use formula:

    =IFERROR(RIGHT(A1,LEN(A1)-255),"")

More Information:

Upvotes: 4

Related Questions