courier font vs Ariel font printing names

[ap1]

ques 1. I am trying to format name field last name followed by first.

Goldstein Andrew P Ellenhorn Theodore J.

like these when i use aerial font they are not alligned when i use courier they get aligned. is there a way to align them using courier


ques 2. Is there a way i can format the last name, first name with no blanks in the middle of first and last name ?

 

[ap1]

i meant can i align them using aerial

 

[Mark W.]

On 2002-03-27 06:07, ap1 wrote:
i meant can i align them using aerial

No. Arial is a proportional font. Courier is a nonproportional font. The letter spacing varies when using a proportional fonts -- a "M" occupies more space that an "a".

 

[Yogi Anand]

On 2002-03-27 06:05, ap1 wrote:
ques 1. I am trying to format name field last name followed by first.

Goldstein Andrew P Ellenhorn Theodore
J.

like these when i use aerial font they are not alligned when i use courier they get aligned. is there a way to align them using courier


ques 2. Is there a way i can format the last name, first name with no blanks in the middle of first and last name ?

Hi ap1:
Mark has answered your first question. Your second question is not clear ... I believe that is why it did not get answered.
Do you mean if you have the name in cell A1

Goldstein Andrew

You will like to have it formulated as

GoldSteinAndrew

If this is the case, then use the formula:

=SUBSTITUTE(A1," ","")

HTH

Please post back if it works for you ... otherwise explain a little further and let us take it from there!

 

[Yogi Anand]

And if you have in cell A1
Goldstin Andrew P
and you want to formulate it as
GoldsteinAndrew P
then use the following formula:
=REPLACE(A1,10,1,)
to get
GoldsteinAndrew P
This message was edited by Yogi Anand on 2002-03-27 19:07