courier font vs Ariel font printing names

ap1 · Mar 27th, 2002, 07:05 AM

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 · Mar 27th, 2002, 07:07 AM

i meant can i align them using aerial

Mark W. · Mar 27th, 2002, 06:05 PM

Quote:

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 · Mar 27th, 2002, 08:00 PM

Quote:

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 · Mar 27th, 2002, 08:06 PM

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 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 27th, 2002, 07:05 AM	#1
ap1 New Member Join Date: Mar 2002 Posts: 26	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 ?

Mar 27th, 2002, 07:07 AM	#2
ap1 New Member Join Date: Mar 2002 Posts: 26	i meant can i align them using aerial

Mar 27th, 2002, 08:06 PM	#5
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	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 ]