Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

0 views
Skip to first unread message

MacAlpine@discussions.microsoft.com Tim MacAlpine

unread,
Nov 6, 2009, 1:02:22 PM11/6/09
to
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

0 new messages