Format Font courier to New Times Roman

[chuaby]

Hi

I have a listing from a text file. In the listing, it is well formatted
eg


Field A Field B
-------------- -----------------
AAAA BBBB
CCCC
DDDD EEEE
FFFF

But when i import into MS Word, it becomes

Field A Field B
-------------- -----------------
AAAA BBBB
CCCC
DDDD EEEE
FFFF

This is due to the char size of the "space" character. If the font is
changed to courier, it is ok. But due to requirement, i cannot use
Courier except New Times Roman or Arial.

May i know is there anyway for me to use a VBA script to align the data
? I have many of such LST files, so i cannot do it manually.

for some advice please
Thank you
Boon Yiang

 

[Jezebel]

Replace the spaces with tabs.

 

[chuaby]

Hi

Thanks for the reply. i have tried but all the space will be replaced
by tab and everything is out again. eg 3 space with 3 tabs, 10 space
with 10 tabs.

i cannot determine how many consequtive space there are to do a
replacement with a single tab as all the fields in col A are of
different length.

Best Regards
Boon Yiang

 

[Graham Mayor]

You were supposed to replace multiple spaces with single tabs!
http://www.gmayor.com/replace_using_wildcards.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Geoff C]

Changing characters to tabs will work, but the basic problem is that you need
a monospace font, like Courier. With these all the characters are the same
width, not just spaces. There might be a monospace font similar in look to
TMR or Ariel somewhere, the following might be useful.

http://www.lowing.org/fonts/

 

[Jezebel]

The whole point of using tabs is that you *don't* then need a monospaced
font. Apart from which, the idea of a 'monospace font similar in look to
TNR' is just typoporn.