LinkBack URL
About LinkBacks
Hi
could anyone come up with a quick solution to just return numbers or "/" from a string of text
ie 0233456/2 = 0233456/2
034hfn34 = 03434
02345(MI) = 02345
RH03FHN = 03
I can remove the text or numbers but cant seem to manage to keep the /
Hi
could anyone come up with a quick solution to just return numbers or "/" from a string of text
ie 0233456/2 = 0233456/2
034hfn34 = 03434
02345(MI) = 02345
RH03FHN = 03
I can remove the text or numbers but cant seem to manage to keep the /
Regards
Sean
Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!
This array formula works with your first example:
=MID(LEFT(A2,MATCH(1,-MID(A2,ROW(A$1:A$99),1),1)),MIN(SEARCH(ROW(A$1:A$10)-1,A2&1234567890)),99)
What are you using for the others?
Maybe you could use =IF(ISNUMBER(SEARCH("/",A1)),myformula,yourformula)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks