Excel Help

[olds]

I have a large Excel file, imported from a PDF.
Every entry of data is on the same line, no colums.
Is there a way to force data into colums?

IE:
....A................................B.........................
1 Data Data Data Data

I need:
.....A......B......C.......D................................
1 Data Data Data Data

 

[el-Capitan]

Try ribbon 'Data', 'Text to columns'. Has done the trick for me many times.

 

[Anubis]

yea text to columns should do it

 

[PowerEngineer]

Not sure how you are converting the file from PDF to Excel, but if you can make it a simple .txt file then you can open that file using Excel and it will walk you through a process for breaking file records down into columns. It looks like all you'll need to do is select 'space' as a delimiter.

 

[olds]

Text to columns didn't work,
For conversion, I have the full acrobat. It's downloaded as a pdf and I save it as an xls.

 

[radhak]

PowerEngineer has a point - you should save it as a text file from the PDF. Then start up Excel and open that text file - it should allow you to go thru a few dialogue boxes where you can specify the delimiters for the fields and other stuff.

 

[olds]

I'll try that.

 

[IronWing]

If the data lines are complicated sometimes it is necessary to use the search and replace function to create a suitable separator between data values prior to employing the text to columns function.

 

[olds]

Not sure how you are converting the file from PDF to Excel, but if you can make it a simple .txt file then you can open that file using Excel and it will walk you through a process for breaking file records down into columns. It looks like all you'll need to do is select 'space' as a delimiter.

PowerEngineer has a point - you should save it as a text file from the PDF. Then start up Excel and open that text file - it should allow you to go thru a few dialogue boxes where you can specify the delimiters for the fields and other stuff.

If the data lines are complicated sometimes it is necessary to use the search and replace function to create a suitable separator between data values prior to employing the text to columns function.

Saving as text and opening in excel helped. The field I need the most didn't get it own column but I can get rid of some of the other stuff I need. Probably too many entries to to search and replace or add a comma to separate them but it's a start.

Thanks guys.