You've discovered what I was going to say: Rick's formulas are more 'generic'
and will cover more general cases, where the ones I provided were tailored to
your data. Not that Rick likes the one I put up for column C better than
his, so you may have a combined 'combined general/specific' solution by using
most of his and one of mine <g


"aileen" wrote:

Thanks so much. This covered even more scenarios for me.

"Rick Rothstein" wrote:

If your strings of data are in cells (Column A assumed below), then try
these formula...

Column B
----------------
=LEFT(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"012345 6789"))-1)

Column C
----------------
=TEXT(LOOKUP(9.9E+307,--LEFT(SUBSTITUTE(A1,B1,""),ROW($1:$99))),"0000")

Column D
----------------
=SUBSTITUTE(SUBSTITUTE(A1,B1&C1,""),E1,"")

Column E
----------------
=LOOKUP(9.9E+307,--RIGHT(A1,ROW($1:$99)))

--
Rick (MVP - Excel)


"aileen" wrote in message
...
I have strings of data as such:
SYG0919L625
SPZ1020X1025
DO0919M25.5

I need to separate these strings into 4 columns delimited by number and
letter. e.g.
The data should look as such:

Col 1 Col 2 Col 3 Col 4
SYG 0919 L 625
SPZ 1020 X 1025
DO 0919 M 25.5

Any ideas?

.