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?
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?
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
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
=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.
=RIGHT(E49, 1)
E49 would be the cell value
http://www.easyexcelanswers.com
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.
can you provide more detail on what you are trying to do
as i said, i suspected there was more to the question
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks