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

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

Making 2 columns is not an option. I am utilizing a long evolved complex
form. The column format I am requesting is cosmetic and not required but if
it can be done I would the ability as it comes up somewhat frequently. Simply
inserting an additional column would require hundreds of manhours worth of
work.


--
Ray


"Ray" wrote:

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