Data Menu Text to columns
"David Biddulph" wrote:
I don't see why you say you can't use LEFT or RIGHT.
What's wrong with
=LEFT(A7,FIND(" ",A7)-1) and
=RIGHT(A7,LEN(A7)-FIND(" ",A7)) ?
--
David Biddulph
"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 for your qick response!
|