View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RaY RaY is offline
external usenet poster
 
Posts: 164
Default VBA to make columns within a cell (99)

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