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

1. ## 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. ## 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

3. ## 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. ## 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

5. ## 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

6. ## 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. ## 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

##### Users Browsing this Thread

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

#### 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