move value to next line for every space inside cell

hi,

i have a value in a cell -- xxxx XXX xx

how do you format it so the cell value will display as

xxxx
XXX
xx

all that value is just inside the cell, the values that move to the next line was separated by spaces

Select the cell(s) that you want to change

Please Login or Register  to view this content.

You can use Find and Replace
Attachment 624491

hi,

thanks for the replies, i used jindon's code