software

I have a quot;Parts sheetquot; that I converted to Excel from a PDF. There are 3
columns ie; 1) part# 2)description amp; 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?

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 quot;normallyquot;, 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:
gt;
gt; I have a quot;Parts sheetquot; that I converted to Excel from a PDF. There are 3
gt; columns ie; 1) part# 2)description amp; 3) price. Instead of each part # having
gt; its own cell in column A, all of the part #'s are in 1 cell. The same is
gt; true for the corresponding descriptions and prices. How can I get each
gt; part/description/price in its own separate cells in a row?

--

Dave Peterson

What I ended up doing is printing the sheet, scanning it amp; 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.

quot;Dave Petersonquot; wrote:

gt; It would depend on what your data looked like.
gt;
gt; If each line within the cell is caused by the user hitting alt-enter (to force a
gt; new line),
gt;
gt; then you could select that column
gt; data|text to columns
gt; delimited
gt; Other (type ctrl-j)
gt; and split the original value into multiple cells.
gt;
gt; If the text just wraps quot;normallyquot;, then you might be able to use formulas--if
gt; the part number is always the same width and the prices are always the same
gt; format.
gt;
gt; But it's difficult to guess toward a solution without more info.
gt;
gt; Magyvr wrote:
gt; gt;
gt; gt; I have a quot;Parts sheetquot; that I converted to Excel from a PDF. There are 3
gt; gt; columns ie; 1) part# 2)description amp; 3) price. Instead of each part # having
gt; gt; its own cell in column A, all of the part #'s are in 1 cell. The same is
gt; gt; true for the corresponding descriptions and prices. How can I get each
gt; gt; part/description/price in its own separate cells in a row?
gt;
gt; --
gt;
gt; Dave Peterson
gt;