This may be easier:
=SUBSTITUTE(A1,char(10),"~")
But you should be able to use alt-0010 or ctrl-j in that text to columns
dialog.
Kathy wrote:
Thanks Dave, I found the answer! :)
Assuming your data starts at A1, put the following formula in B1:
=SUBSTITUTE(A1," ","~")
In between the empty quotes, instead of a space hit Alt-Enter.
Copy the formula down to match your list of data. Then select all of the
formulas and Copy, then Paste / Special / Values.
Now do a Text To Columns using "~" as the delimiter.
"Kathy" wrote:
Chip, Is it possible to change the line break to "Text to Columns"
"Chip Pearson" wrote:
In the "Find What" box of the Replace dialog, hold down your left ALT key
and type 0010 on the numeric keypad (not the number keys above the letters).
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
"Impish" wrote in message
...
Want to use Ctrl-H to replace a specific character in a range of cells
with a
line break (Alt+Enter) - how do I access special characters? (^p didn't
work)
--
Dave Peterson