Hi,
ok lets say we have an address in a cell, like
Teststreet 22 B, Testtown
What i want is to get the all text after the first "2" - 22 B, Testtown
I'm stuck at the moment....
Hi,
ok lets say we have an address in a cell, like
Teststreet 22 B, Testtown
What i want is to get the all text after the first "2" - 22 B, Testtown
I'm stuck at the moment....
See if the attached workbook helps
If you have any questions about the formula used, just ask!
mew!
=IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
thanks for your reply
it dosn't quite work for me, the "2" was only an exemple
adsfdsf 2345f fdsgfsda --> 245f fsfdsgfsda
adds21 fdsdd 3 --> 21 fdsdd 3
dff11 d --> 11 d
what i want to extract is any text after the first alphanumerical letter, which can be anything between 0-9.
Hi,
=REPLACE(A1,1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&1234567890))-1,"")
HTH
Kris
The formula =right(A1,n), where n is any number, extracts n characters starting right to left. This formula is useful if you need to extract fixed number of charactes from column A, as you can drag the formula, but is not tha useful if in every row you need to extract different number of characters. Anyways, see if you can use this somehow
Alsa, it works with =left(a1,n)
This code works for any single cell
And I think you can extrapolate for any given range. Hope that helps,Please Login or Register to view this content.
Last edited by agentred; 11-04-2009 at 11:40 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks