Results 1 to 3 of 3

Thread: Concatenate Formula not working

  1. #1
    Join Date
    Jan 2009
    Posts
    110

    Concatenate Formula not working

    Hello friends,

    I am facing an issue in my Excel sheet,I have been using the concatenate function from a long back but now it just stopped working and these are numerical columns. I normally go to insert option - - > Function - - >Concatenate.

    Can anyone fix this issue fro me.I would be very great full to him.

  2. #2
    Join Date
    Dec 2008
    Posts
    101

    Re: Concatenate Formula not working

    Sure i will help you out with this try to use this formula =CONCATENATE(B2,C2,D2,E2) and make sure your calculation tab is in automatic mode.


    Intel Core 2 Duo 2.8 Ghz
    G31 Asrock Motherboard with Intel chipset
    2gb RAM
    256 Nvidia Graphic Card
    200gb HDD

  3. #3
    Join Date
    May 2008
    Posts
    4,345

    Re: Concatenate Formula not working

    I was also facing similar type of issue i try to disable the TFE or AEE option.

    For that you need to follow the below steps:-

    1. Click on Tools Menu, then click on Preferences and click the Transition tab.
    2. Now under Sheet Options, clear the Transition Formula Evaluation check.

Similar Threads

  1. ASUS AHCI/RAID Crosshair IV Formula not working
    By Yogisa in forum Motherboard Processor & RAM
    Replies: 6
    Last Post: 20-08-2011, 11:20 PM
  2. MS Project - Concatenate text
    By JasonHik in forum Windows Software
    Replies: 0
    Last Post: 25-10-2009, 07:13 AM
  3. Random Function to Concatenate 2 strings
    By klite in forum Software Development
    Replies: 3
    Last Post: 14-10-2009, 11:48 AM
  4. Concatenate avi files
    By Abhiraj in forum Tips & Tweaks
    Replies: 3
    Last Post: 21-08-2009, 05:43 PM
  5. How to concatenate excel files ?
    By Abshir in forum Windows Software
    Replies: 3
    Last Post: 12-05-2009, 03:22 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,629,822.93225 seconds with 17 queries