Split Single Long Text String into 3 or more columns with max characters

[Cooper412]

Hi,
I'm attempting to split a text string into multiple columns and need to limit the number of characters per column. I have a sample formula that works but can't limit the number of characters in column 2 and dump in column 3.

Sample
A1: Service First Restoration DBA Plumbing Concepts FBO Adam Smith

B1 (max 20 characters): =TRIM(LEFT(A1,FIND("%%",SUBSTITUTE(A1," ","%%",20-LEN(SUBSTITUTE(LEFT(A1,20)," ","")))))) ....Works fine!!
C1: (max 15 characters): =TRIM(SUBSTITUTE(A1,B1,"")) .......Formula currently dumps rest of A1 in C1. Needs character restriction to 15 and dump the rest in D1
D1: (max 35 characters): ????

Current result
A1: Service First Restoration DBA Plumbing Concepts FBO Adam Smith
B1: Service First
C1: Restoration DBA Plumbing Concepts FBO Adam Smith (should only be 15 characters)
D1: Need a formula and limit to 35 characters

Thank you in advance!!

 

[FDibbins]

Hi, welcome to the board.

Without testing, it sounds like you need to set the max per column based on a cumulative value (C1 should start at 21 and end at 35)
either that, or use that TRIM that you have, and build that into the LEFT function