Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"NatChat" wrote in message
...


"Ragdyer" wrote:

In B1 enter:
=LEFT(A1,FIND(" ",A1)-1)

In C1 enter:
=RIGHT(A1,LEN(A1)-LEN(B1)-1)

Select *both* B1 and C1, and copy down as needed.
--
HTH,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-
"NatChat" wrote in message
...
Can you use a formula to split delimited data when number of
characters in
each cell varies (rather than using Text to columns from Data menu).

For example:
Column A
1 Smith Sue
2 Wilson Jane
3 Vincent Michael

I want to split this data delimited by a space but can't use LEFT or
RIGHT
functions as number of characters varies in each cell.

Please advise.

Thank you for your help!

Thanks so much for your quick response. The formulae you gave me work
perfectly! I didn't know about the "FIND" function before. Thanks again.