Thread: How to convert De-limited text file to excel

I have a text file de-limited with tab. I need to convert the same file to
excel and use chart options to draw a graph. Though i am able to import the
text file in to excel file i am unable to draw graph with that data. Please
help me do it.

Maybe the 'numbers' in the data are being seen as text, try entering 1
anywhere on the sheet and copying it. Then highlight the 'numbers' and do
Edit>Paste special...>Values+Multiply

This should kick the text numbers to actual ones and you should then be able
to chart it

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Venkatesh S" <Venkatesh S@discussions.microsoft.com> wrote in message
news:F72FE37C-06D7-463F-86A2-ED4AB52E60A4@microsoft.com...
>I have a text file de-limited with tab. I need to convert the same file to
> excel and use chart options to draw a graph. Though i am able to import
> the
> text file in to excel file i am unable to draw graph with that data.
> Please
> help me do it.

Have you done the <data><text to Column> step>


"Venkatesh S" wrote:

> I have a text file de-limited with tab. I need to convert the same file to
> excel and use chart options to draw a graph. Though i am able to import the
> text file in to excel file i am unable to draw graph with that data. Please
> help me do it.

Let me save you the trouble of typing 1, then deleting it later. Copy a blank cell,
then do Edit menu > Paste Special > Values + Add.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Nick Hodge wrote:

> Maybe the 'numbers' in the data are being seen as text, try entering 1
> anywhere on the sheet and copying it. Then highlight the 'numbers' and do
> Edit>Paste special...>Values+Multiply
>
> This should kick the text numbers to actual ones and you should then be able
> to chart it
>