Hi
I need help to find a formula for the following:
1. I have a string 4-75MM which needs to be replaced as 4.75mm - I am currently using the formula =REPLACE(REPLACE("4-75MM",FIND("-","4-75MM",1),1,"."),FIND("MM","4-75MM",1),2,"mm") to do this but a better solutions is welcome
2. Most importantly what i want is to then find the index of this resultant string "4.75mm" in an array.
I have attached an example xl which explains this better.
Regards
docGee
will tell you if there is a dash in the second position of any string in col A.
Please Login or Register to view this content.
will give you the row (index) number.Please Login or Register to view this content.
Combining #1 & #2:
Please Login or Register to view this content.
Ben Van Johnson
Hi protonLeah
What i want is to find which position (index) in the array of A:A is "4.25mm - ...."?
Try this (I get 13)
=MATCH(TRUE,ISNUMBER(SEARCH("4.75mm",A1:A19)),0)
Maybe:
=MATCH(SUBSTITUTE(B20,"-",".")&"*",A:A,0)
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
Thanks Glenn. That works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks