Hi,
You can also use Data Text to columns. Select delimited and then click
Next. On the next screen, uncheck tab and check the "Other" box. In the
box next to Other, do the following
Alt+010 (on the numeric keypad)
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Josh O." wrote in message
...
I could use some help making a formula to return all characters before a
carriage return [or an alt-enter or Char (10), depending on how you referr
to
it].
The Cell has a lot of text in it and can have more than 1 carriage return
in
it...
Any ideas?