LinkBack URL
About LinkBacks
I have copied a line of 15 values from a pdf file into excel, but they all appear in one cell with a space in between each value. Is there a way to automatically separate these values into 15 different cells?
I have copied a line of 15 values from a pdf file into excel, but they all appear in one cell with a space in between each value. Is there a way to automatically separate these values into 15 different cells?
Select cell (or cells, or column) with your data and do the following:
Data -> Text to columns (find it for 2003)
Delimited
choose space
Finnish
Never use Merged Cells in Excel
See Data: Text to columns... in Help
Ben Van Johnson
Hi waj42 and welcome to the forum.
Find the example on the attached. Put your string in A1 and this formula in B1 and pull across and down.
Please Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
I'm with zbor text to columns is probably easiest but I'd use English not Finnish
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
I thought that people from Tennessee write Finnissh in Ennglissh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks