Excel data import of tab-delimited text sees capital 'F' as delimi

T

Tim MacAlpine

Has anyone come across a situation where, when importing a tab-delimited text
file as data, text strings containing a capital 'F' get broken into seperate
fields at the 'F'?

If I enclose the text strings containing the 'F' with double-quotes they are
accepted as is. If I change the capital 'F' to a lower-case 'f' there is no
problem. I can't find any reference to why the Excel data import would
interpret a capital 'F' as a tab delimeter. Any input would be appreciated.

Thanks!

Tim
 

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

Top