Thread: Formula Help
View Single Post
 
Old 02-14-2013, 12:02 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Catalin: Tony specified
Quote:
without Excel using the comma as a numerical delimiter
Your post seems to assume the exact opposite.

Tony: I think you can get what you're after if you use Data|Get External Data > From Text. Navigate to and Selection the file, then click Import. When the Text Import Wizard pops up, choose Delimited > Next, then choose the Tab delimiter, making sure the other options are cleared. Click Finish then coose the destination.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote