Splitting Cells

J

Jess

I have a pdf with tables of data. I converted it to Word with Acrobat. The
data for each column is in one cell. Ex: All the costs for each item is in 1
column - but 1 cell instead of 1 column several cells. When I copy and paste
to excel it does the same thing. (Each column of data in one cell.) Is there
a way in excel to search for a space and replace with split cells. And the
document is 58 pages long.
 
G

Gilles Desjardins

Jess, click on Data, Text to columns, Delimited and click on space then
finish. This should do it.

Gilles
 
Top