Results 1 to 21 of 21

VBA: Concatenate cell data one below another using the formula not working

Threaded View

  1. 07-09-2021, 12:39 PM #1
    zeo1
    zeo1 is offline
    Registered User
    Join Date
    02-03-2021
    Location
    London
    MS-Off Ver
    2007
    Posts
    37

    VBA: Concatenate cell data one below another using the formula not working

    I have thousands of lines of text in cells of columns B and C in excel sheet1. There are empty cells in some places.
    I am trying to concatenate the text one below another using the formula =B2&CHAR(10)&C2 in the respective cells in D but the formula is not working.
    Please help.
    Last edited by zeo1; 07-10-2021 at 02:30 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Concatenate values from Text Boxes into 1 cell not working
    By moosmahna in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-16-2017, 05:20 AM
  2. [SOLVED] lookup formula is not working when referencing a cell's data rather than the actual data
    By Ian281071 in forum Excel General
    Replies: 5
    Last Post: 05-21-2015, 02:33 PM
  3. [SOLVED] Countifs and concatenate formula not working
    By ensmith in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-06-2014, 03:50 PM
  4. excel formula working on a cell which is having data in a data validation cell
    By sujithy007 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-16-2013, 04:18 AM
  5. excel formula working on a cell which is having data in a data validation cell
    By sujithy007 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-16-2013, 04:05 AM
  6. Concatenate Formula not working for all rows
    By jenkimbell in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-19-2012, 11:40 AM
  7. [SOLVED] Can I concatenate text in cells to make a working formula?
    By Matt S. R. in forum Excel General
    Replies: 11
    Last Post: 11-11-2005, 11:50 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1