"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