My problem is probably very simple:
I have column A with entries such as 101011R1R
In column B, I would like to get just the numbers, eg 1010111
Any ideas?
Thanks in advance,
Gavin
My problem is probably very simple:
I have column A with entries such as 101011R1R
In column B, I would like to get just the numbers, eg 1010111
Any ideas?
Thanks in advance,
Gavin
Last edited by gavster; 11-18-2010 at 12:29 PM.
If the letters are always Rs:
=SUBSTITUTE(A1,"R","")
Otherwise
=LEFT(A1,6)&MID(A1,8,1)
Ron
Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad
Kindly
[1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
[3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated
Excellent.
Will have to determine which is most suitable, probably the second.
Thanks a lot.
Gavin.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks