wrapped text cell
 

I have a "Parts sheet" that I converted to Excel from a PDF. There are 3
columns ie; 1) part# 2)description & 3) price. Instead of each part # having
its own cell in column A, all of the part #'s are in 1 cell. The same is
true for the corresponding descriptions and prices. How can I get each
part/description/price in its own separate cells in a row?

wrapped text cell
 

It would depend on what your data looked like.

If each line within the cell is caused by the user hitting alt-enter (to force a
new line),

then you could select that column
data|text to columns
delimited
Other (type ctrl-j)
and split the original value into multiple cells.

If the text just wraps "normally", then you might be able to use formulas--if
the part number is always the same width and the prices are always the same
format.

But it's difficult to guess toward a solution without more info.

Magyvr wrote:

I have a "Parts sheet" that I converted to Excel from a PDF. There are 3
columns ie; 1) part# 2)description & 3) price. Instead of each part # having
its own cell in column A, all of the part #'s are in 1 cell. The same is
true for the corresponding descriptions and prices. How can I get each
part/description/price in its own separate cells in a row?

--

Dave Peterson

wrapped text cell
 

What I ended up doing is printing the sheet, scanning it & saving it in a
WORD format as a table and then taking each column and copying and pasting to
my excel worksheet. It sound somewhat complicated but actually it wasn't.
Thanks for your help.

"Dave Peterson" wrote:

It would depend on what your data looked like.

If each line within the cell is caused by the user hitting alt-enter (to force a
new line),

then you could select that column
data|text to columns
delimited
Other (type ctrl-j)
and split the original value into multiple cells.

If the text just wraps "normally", then you might be able to use formulas--if
the part number is always the same width and the prices are always the same
format.

But it's difficult to guess toward a solution without more info.

Magyvr wrote:

I have a "Parts sheet" that I converted to Excel from a PDF. There are 3
columns ie; 1) part# 2)description & 3) price. Instead of each part # having
its own cell in column A, all of the part #'s are in 1 cell. The same is
true for the corresponding descriptions and prices. How can I get each
part/description/price in its own separate cells in a row?

--

Dave Peterson