Concatenate function WON'T concatenate!! Why?
Upcoming Power Excel Seminars
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Concatenate function WON'T concatenate!! Why?

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

    Default

     
    Hi, Folks! Hope someone can help me!

    Am trying to use concatenate function to two cells - the results in the function dialog box are correct as I select cells to apply the fucntion to - BUT when I click OK, the results cell contains the formula and NOT the result. I'm seeing the same thing attempting other text functions, as well!

    Can anyone give me an idea of why this behavior is happening? Anyone else experienced such a thing?

    Thanks for your assistance!!

    CR

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-04 11:18, mobius wrote:
    Hi, Folks! Hope someone can help me!

    Am trying to use concatenate function to two cells - the results in the function dialog box are correct as I select cells to apply the fucntion to - BUT when I click OK, the results cell contains the formula and NOT the result. I'm seeing the same thing attempting other text functions, as well!

    Can anyone give me an idea of why this behavior is happening? Anyone else experienced such a thing?

    Thanks for your assistance!!

    CR
    Try:

    Tools/Options/View then check to see if the Formulas box is checked, it shouldn't be.

    Any help
    "Have a good time......all the time"
    Ian Mac

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

    Default

    Ian: Thanks, but no good so far - my box is unchecked ... the problem seems to be with macros embedded in the spreadsheet. I notice that any .xls's with macros exhibit the inability to run functions!

    I'm trying to see if anyone else is seeing the same nonsense.

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-04 13:07, mobius wrote:
    Ian: Thanks, but no good so far - my box is unchecked ... the problem seems to be with macros embedded in the spreadsheet. I notice that any .xls's with macros exhibit the inability to run functions!

    I'm trying to see if anyone else is seeing the same nonsense.
    Send me your book if you want
    "Have a good time......all the time"
    Ian Mac

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

    Default

    Ian:
    Thanks for the offer, but I think I've got it figured out - Excel doesn't like to concatenate numbers which have been formatted as text (i.e. zipcode data) - by using 'general' format I've fixed most problems.

    Thanx again!

    CR

  6. #6
    New Member
    Join Date
    Jul 2014
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Concatenate function WON'T concatenate!! Why?

    I'm using =B1 & ", " & b2 and all I am seeing is the formula. Works in other books. I have excel 2010. Where is this formulas box in excel 2010... I can't find it!
    Thanks.

    Quote Originally Posted by Ian Mac View Post
    Try:

    Tools/Options/View then check to see if the Formulas box is checked, it shouldn't be.

    Any help

  7. #7
    New Member
    Join Date
    Jul 2014
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Concatenate function WON'T concatenate!! Why?

    Tried it with the concatenate function, too, and All I seen is the function, not the results. I do have a macro in the workbook.

  8. #8
    MrExcel MVP Rick Rothstein's Avatar
    Join Date
    Apr 2011
    Location
    New Jersey, USA
    Posts
    31,171
    Post Thanks / Like
    Mentioned
    39 Post(s)
    Tagged
    9 Thread(s)

    Default Re: Concatenate function WON'T concatenate!! Why?

      
    Quote Originally Posted by byrdieep View Post
    Tried it with the concatenate function, too, and All I seen is the function, not the results. I do have a macro in the workbook.
    It sounds like the cell you are putting the formula in is formatted as TEXT, try changing it to GENERAL and then re-enter your formula and see if that works.
    Rick's "mini" blog... http://www.excelfox.com/forum/f22/
    .
    Want to post a small screen shot? See Part B here.

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
  •  

 

 
DMCA.com