Results 1 to 4 of 4
  1. #1
    akkwoody
    Guest

    Concatenate (XP)

    I'm having a problem concatenating two text fields. In F1 my formula reads: =D1&E1 However, instead of evaluating the expressing, that cell displays the formula. Same in F2, which reads:
    =CONCATENATE(E2,D2). Do I have to do something to get Excel to show the result of the formula? I haven't done this concatenation thing in a long time, but I don't remember it being so hard!
    Thanks for any help, Allie

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Concatenate (XP)

    You need to make sure the cell with the formula is not formatted as text, so it is best to format it as general. If that does not work immediately, select the cell and and then goto the formula bar and press F2.

    Also just make sure that View Formulas is not checked in the Window options (Tools, Options, View).

    Andrew C

  3. #3
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Concatenate (XP)

    OK you say <<<that cell displays the formula >>> Check to see if your Display Formulas is checked under the Tools menu choose Options, and activate the View Tab and Under Windows Options see if you have a check mark in the first column second row next to Formulas.

    If not, I am still afraid of Excel XP , maybe someone who has installed it will tell you.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  4. #4
    akkwoody
    Guest

    Re: Concatenate (XP)

    Thank you very much!!! The formatting fixed the problem.

Posting Permissions

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