Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: courier font vs Ariel font printing names

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ?

  2. #2
    New Member
    Join Date
    Mar 2002
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    i meant can i align them using aerial

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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".

  4. #4
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!

    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  5. #5
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •