Function on "Text to Columns"

  • Thread starter Thread starter Nandeesh
  • Start date Start date
N

Nandeesh

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
 
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
 
Hi

You need to select two delemiters in this case, comma and in others type
"-".

Hopes this helps.

Per
 
Nandeesh said:
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
Click to expand...

Using "Text to Columns", select "Delimited" and "Next". Then check "Space",
"Comma" and "Treat consecutive delimiters as one" and then click "Next". In the
next dialog box, select the third column (with the hyphen "-" in it) and select
the Column data format "Do not import column (skip)". Click "Finish".
 
Back
Top