Use a formula to substitute the carriage return with your required substitute.
Example:
=SUBSTITUTE(A643,CHAR(13),". ")
Saturday, October 29, 2011
Wednesday, July 20, 2011
Woo Hoo!
Now I have a (yet another) blog for keeping track of Excel tips and tricks. Hope to learn something during this!
Subscribe to:
Posts (Atom)