L
Lostguy
Hello,
If I type in dog;cat;fish;cow;rat in cell A1, what I want in cell B1
is:
dog
cat
fish
cow
rat
stacked on top of each other.
I used =substitute(a1,";",char(10)) and checking "word wrap", so now
it looks like it is supposed to.
But when I add more entries in cell A1, I don't know of a way to get
the cell to expand row height so the entries don't scroll off. And
when I reduce entries down to three, the cell should shrink.
Basically, the height of the row should match the contents.
Can this be done non-VBA?
Thanks for all your help with this and past questions!
VR/
Lost
If I type in dog;cat;fish;cow;rat in cell A1, what I want in cell B1
is:
dog
cat
fish
cow
rat
stacked on top of each other.
I used =substitute(a1,";",char(10)) and checking "word wrap", so now
it looks like it is supposed to.
But when I add more entries in cell A1, I don't know of a way to get
the cell to expand row height so the entries don't scroll off. And
when I reduce entries down to three, the cell should shrink.
Basically, the height of the row should match the contents.
Can this be done non-VBA?
Thanks for all your help with this and past questions!
VR/
Lost