+ Reply to Thread
Results 1 to 3 of 3

Formula to get text from cells

  1. #1
    Registered User
    Join Date
    02-27-2020
    Location
    Australia
    MS-Off Ver
    365
    Posts
    6

    Formula to get text from cells

    Hi
    I'd love some help to create the following formula. I think it should be pretty simple but I just can't work it out!
    Columns A, B and C contain text, however some cells are blank.
    I would like a formula that pulls the text in a given row from column A, however if the cell in column A is blank it pulls the text from the cell in column B and if the cells in column A and B are both blank then it pulls the text from the cell in column C.
    Thanks in advance

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Formula to get text from cells

    Hi and Welcome.

    maybe something like this

    Please Login or Register  to view this content.
    Happy with my advice? Click on the * reputation button below

  3. #3
    Registered User
    Join Date
    02-27-2020
    Location
    Australia
    MS-Off Ver
    365
    Posts
    6

    Re: Formula to get text from cells

    You are amazing. Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to Insert text/formula in to cells based on the text in the cell beside
    By mikeymeteora in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-25-2020, 07:32 PM
  2. Replies: 2
    Last Post: 07-08-2017, 04:07 AM
  3. Formula to copy text from a cell, if two other cells have the same text
    By busybee02 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-19-2014, 07:35 PM
  4. Replies: 3
    Last Post: 05-13-2014, 10:48 PM
  5. Formula needed for dividing 2 sets of cells and excluding adjacent text cells
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-07-2013, 06:45 PM
  6. [SOLVED] TEXT Formula to identify rows of cells with Matching TEXT *** Actual Worksheet attached.
    By steve08087 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-29-2013, 12:42 PM
  7. Replies: 3
    Last Post: 01-31-2012, 12:40 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