text to columns options

[synergy16]

good morning all. i have a text column that has names as LastFirst but they together and i need to split them into 2 columns. is there a way to use "text to columns" using a change in text case as a delimiter? for example

SmithJoe in 1 columns needs to be Smith Joe in 2 columns.

note: doesnt have to be done via "text to columns" was just using that as an example

 

[Fluff]

You can't do it with text to columns, but you could use

Fluff.xlsm
	A	B	C
1
2	SmithJoe	Smith	Joe
Data

Cell Formulas
Range	Formula
B2	B2	=TEXTBEFORE(A2,CHAR(SEQUENCE(26,,65)),2)
C2	C2	=SUBSTITUTE(A2,B2,"")

 

[synergy16]

You can't do it with text to columns, but you could use

Fluff.xlsm
	A	B	C
1
2	SmithJoe	Smith	Joe
Data

Cell Formulas
Range	Formula
B2	B2	=TEXTBEFORE(A2,CHAR(SEQUENCE(26,,65)),2)
C2	C2	=SUBSTITUTE(A2,B2,"")

that worked nicely. thank you

 

[Fluff]

You're welcome & thanks for the feedback.