See that 99, the old Ctrl+J trick, that's the third time I've missed it this
year!

<g
Martin

"Dave Peterson" wrote in message
...
You could also use ctrl-j instead of the alt-0010 (from the numeric
keypad).

(Easier to do and easier to explain <bg)

MartinW wrote:

Hi Faraz,

Just do an EditReplace in place
Replace What: space
Replace With: Alt+0010
Click replace All

HTH
Martin

"FARAZ QURESHI" wrote in message
...
I have a data like:
A1: ABCDEFG, HIJK, LMNOPQRSTUV, WXYZ
A2: ABC, DEFG, HIJK, LMNOPQRSTUV, WXYZ
A3: ABCDEFGHIJK, LMNOPQRSTUV, WXYZ

Shall appreciate a formula using Replace and Char(10) function in cells
B1,
B2, B3 or ANY other way so as to present the data as:

B1: ABCDEFG,
HIJK,
LMNOPQRSTUV,
WXYZ
B2: ABC,
DEFG,
HIJK,
LMNOPQRSTUV,
WXYZ
B3: ABCDEFGHIJK,
LMNOPQRSTUV,
WXYZ


--

Dave Peterson