Ray,
IMO you are making life difficult for yourself trying to fight against Excel
rather than accepting its abilities/limitations.
Use 2 columns, unless you a good not to.

NickHK

"Ray" wrote in message
...
I am trying to combine two columns of text into one cell but formatted so
it
still looks like 2 columns. I know how to write to a text file using the
tab
function but is there a similar command for VBA? I can use spaces to do it
but that only works with courier text (fixed width). An example shown
below.
They key is I want this done within 1 cell. Notice the left side is left
justified and the right side should be right justified.

124 ABGY
13 x
19 12

--
Ray