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