Capture texts in one cell
"Joe" wrote in message
...
Hi,
Is it possible to actually capture more than one text in
one cell using VBA? if yes how to go about it?.
example, within a cell, i have
Daily b
Daily r
why would you want to do this? If it is just for presentation, then pushing
Alt+Enter while typing in a cell will allow you to insert a carriage return
in the text. If you want the functionality of a layout like:
A B C
Daily b | Stuff | More
1 ----- | |
Daily r | Here | Text
then you can't split a cell into two. What you can do is merge all the
cells to the right together by column (select a top-bottom pair (i.e. B1 and
B2), format-cells-alignment : merge cells. this will give you:
A B C
1 Daily b | Stuff | More
----------------
2 Daily r | Here | Text
Iain King
|