+ Reply to Thread
Results 1 to 3 of 3

Insert complete text and numeric values from one cell as partial text in another cell

  1. #1
    Registered User
    Join Date
    03-01-2016
    Location
    Alaska
    MS-Off Ver
    Excel for Mac 2011
    Posts
    6

    Insert complete text and numeric values from one cell as partial text in another cell

    Long time lurker, first time poster...

    I would like to take the text found in cell J60 and insert it mid-sentence or mid phrase in A53. A53 currently says "Ledger Balance ($1.25M Start)". It's currently not a function or formula at all, just text. J60 has the number "2.00" in it. I would like to insert J60 right in the middle of the text currently found in A53 so that I can cane J60 and update the cell A53 to read "Ledger Balance ($2.00M Start)" or any other value I choose.

    Similarly, I would like to insert the text found in J58 which is "Client" and fill it in across the top of the document as the title. B2-M2 is a merged cell with the title "Hypothetical Example (Client)". I would like to be able to fill in the client name in J58 and have it populate the title of the spreadsheet across the top.

    Any help would be much appreciated.

    Thank you for looking.

    Rick

  2. #2
    Registered User
    Join Date
    01-08-2014
    Location
    Missouri
    MS-Off Ver
    365
    Posts
    87

    Re: Insert complete text and numeric values from one cell as partial text in another cell

    In cell A53, paste this formula:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    In merged cell B2-M2, paste this formula:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-01-2016
    Location
    Alaska
    MS-Off Ver
    Excel for Mac 2011
    Posts
    6

    Re: Insert complete text and numeric values from one cell as partial text in another cell

    Thank you so much ikeene. You nailed it. It appears I couldn't get the sequence of quotation marks and parenthesis correct.

+ 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. [SOLVED] Compare a text cell with a numeric cell and output a text string
    By ids in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-25-2014, 07:39 AM
  2. Formula to identify part of a text in cell from range of cells & insert adjacent cell text
    By Novicebutnotforlong in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-19-2013, 02:11 AM
  3. [SOLVED] Find partial text string within another text string return original text into cell.
    By mikey42979 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-17-2013, 02:58 PM
  4. [SOLVED] Makro with if condition to check for numeric and text values in a cell range
    By Postlki1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-14-2013, 07:53 AM
  5. [SOLVED] Seperate limited text from a cell contaning alpha numeric values
    By Varun13 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 08-19-2012, 01:43 PM
  6. matching partial text within one cell to partial text within another
    By Solstice in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-03-2010, 09:13 PM
  7. Replies: 2
    Last Post: 10-30-2007, 12:12 PM
  8. Applying numeric values in one cell based on text in another
    By Chi_TechWriter in forum Excel General
    Replies: 3
    Last Post: 02-03-2006, 04:15 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