Jen wrote:
Hi!
Can anyone help me with a formula for Excel 2003 to split data from 1 column
into 2?
Data Examples:
COUN1234
PS3524
PSY5002
I want to have a formula to split the alpha data from the numeric data. As
you can see, the alpha data is of varying lengths.
Thanks ahead of time for anyone who can assist with this!
-Jen;-)
Jennifer Moulton
The following two array formulas (commit with CTRL+SHIFT+ENTER) will work:
=LEFT(A1,MATCH(1,--ISNUMBER(--MID(A1,ROW(INDIRECT("1:"&(LEN(A1)))),1)),0)-1)
=--MID(A1,MATCH(1,--ISNUMBER(--MID(A1,ROW(INDIRECT("1:"&(LEN(A1)))),1)),0),LEN(A1 ))