point as delimiter

A

Amber

When I import data from an external source into Excel, I want Excel to
recognize ";" to be a delimiter for text to columns. However, in addition to
";", Excel recognizes "." as a delimiter.

For example: "A. Watson; London" is put into 3 columns (A and Watson and
London), but I would like to have it in 2 (A. Watson and London).

When checking the default setting in text to columns, it shows "tab" and
"semicolon" as delimiters, and not ".". How can I remove "." as a delimiter,
while it is not shown in the default setting?

Thanks.
 
S

Sheeloo

There might be a tab after A. in your data...
Remove the checkbox against TAB and just say ; against OTHER:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I split contents of cell with no delimiter 4
Changing the default delimiter 1
Text to columns 2
save as CSV - changing delimiter 6
Using ~ as a delimiter for Excel file saves 2
Create a flat file in Excel 4
how do I remove line breaks from several cells? 6
Park and Ride in to Central London? 2

Top