I was able to separate Antony, John - 30022275 in to three cells using Data
| Test-to-Column
I used the Delimited options and specified: comma, space, other {in which I
entered the hyphen}, and Treat consecutive delimiters as one
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Nandeesh" wrote in message
...
I have list of Names for e.g.
Antony, John - 30022275
David, Joan - 30022277
When I used "Text to Columns" function I am able to saparate Names in
different cells but unable to saparate "Joan - 30022277"
I tried even removing " - " but did not worked, is their any function so
that I can saparate all for e.g.
A1 - Antony
B1 - John
C1 - 30022275