Splitting Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Jess, click on Data, Text to columns, Delimited and click on space then
finish. This should do it.

Gilles
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Moving a bunch of data 1
Excel lookup across entire workbook 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Split column contents (de-concantenate) 7
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Extracting data from Multiple columns to a Single row 1
Scatter plot / Data from matrices? 1

Back
Top