Capture texts in one cell

J

Joe

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
 
G

Guest

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
 
I

Iain King

Joe said:
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
Click to expand...

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
 
Top