Results 1 to 7 of 7

Append texts into one string from 4 cells that each cell has a formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-03-2012
    Location
    USA
    MS-Off Ver
    2010
    Posts
    496

    Append texts into one string from 4 cells that each cell has a formula

    Hi,
    I have problem to append texts into one string from 4 cells that each cell has a formula.

    I can join all the texts from 4 cells in cell A1 using A1&A2&A3&A4, but cell B1, C1 and
    D1 blocks the length of the text. I do not want to widen cell A1 to show the full length of text,
    and delete the formulas in B1,C1 and D1. Please see more in the attached file.

    Thanks

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. excel formula to grab first text in a string of texts
    By ewong in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-21-2012, 07:08 PM
  2. if cell includes string, append a character to the value of another cell.
    By robbyvegas in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-04-2012, 12:08 AM
  3. [SOLVED] How to Find and Replace a string if cell does not contain certain texts.
    By windcloud2 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-04-2012, 01:04 PM
  4. Adding(Append) fix string before a particular cell
    By prayami in forum Excel General
    Replies: 1
    Last Post: 01-02-2008, 05:29 PM
  5. Compare a string in two columns, if match then append string from third column
    By Londonderry in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-22-2007, 03:41 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1