+ Reply to Thread
Results 1 to 7 of 7

Formula to take value of cell, remove specific text from it, then place it in active cell

  1. #1
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    298

    Formula to take value of cell, remove specific text from it, then place it in active cell

    So if

    D2 = "Unit 6"

    I want C2 to be: =D2(remove text "Unit ") so that just the number remains.

    What's the formula for this?

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,577

    Re: Formula to take value of cell, remove specific text from it, then place it in active c

    Are you always looking to remove "Unit"
    =TRIM(REPLACE(A1,1,5,""))+0
    ChemistB
    My 2

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Formula to take value of cell, remove specific text from it, then place it in active c

    If the number is always just 1 digit, try

    =RIGHT(D2)

    If it can be multiple #s as well, then

    =RIGHT(D2,LEN(D2)-5)+0

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    7,233

    Re: Formula to take value of cell, remove specific text from it, then place it in active c

    =value(right(d2,1))
    but i suspect theres more to your question
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  5. #5
    Forum Contributor
    Join Date
    12-16-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    109

    Re: Formula to take value of cell, remove specific text from it, then place it in active c

    =RIGHT(E49, 1)

    E49 would be the cell value

    http://www.easyexcelanswers.com

  6. #6
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    298

    Re: Formula to take value of cell, remove specific text from it, then place it in active c

    It may not always be in the D column, I just picked random letters to develop a formula. I will try what you guys posted so far.

  7. #7
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    7,233

    Re: Formula to take value of cell, remove specific text from it, then place it in active c

    can you provide more detail on what you are trying to do
    as i said, i suspected there was more to the question

+ 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] VBA code needed to place a specific text in a cell when an email is sent, to avoid duplic
    By Jim885 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-23-2014, 09:19 PM
  2. [SOLVED] Place text in adjoining cell if cell contains specific text
    By xrayexceller in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-05-2013, 11:27 PM
  3. Replies: 19
    Last Post: 04-10-2013, 08:30 AM
  4. Replies: 2
    Last Post: 12-23-2012, 09:26 AM
  5. [SOLVED] How do I remove all text in a cell after a specific character?
    By Erik Millerd in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 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