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


please advise.

regards,
Joe

As far as I know you can only get out the entire content
of the cell. However, once you have that you can use f.i.
the Split function to get different parts of the string
if you have some unique character(s) to split on.

ojv
-----Original 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


please advise.

regards,
Joe
.

"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