1-1

Hi, I have the following in D2 which contains "David & Rose Smith =iferror(LEFT($C2,(FIND(" ",$C2,1)-1)),C2) I want to test for strings listed in the named range, "NOGOOD". If none of the string are in C2, I'd like to apply above. If any of the stings in NOGOOD appear in C2, the result...

Hey all, I am looking to select a column range up until the character "-" is encountered. The array is C8 to C17. I tried the following: =OFFSET(C8, 0, 0, MATCH("-", C8:C17, 1)-1, 1) But wasn't quite working as expected. Any help would be much appreciated Cheers

Hi I have the following VBA program that works but I would like to make two changes and just not having any luck. The first change is to have the existing "1-1" accept any number combination (say 1-99 or 99-1) right now it only accepts 1-1 as a positive result. My second request is to the have...

Hi, I have multiple rows where my cells look something like this: "+USD 17,286.24" or "-USD 40,918.66" . I just want to extract the number and I'm using this formula: =RIGHT(F9,(FIND(" ",F9,1)-1)) which works on every other cell I have except where the format reads like my examples above. Any...

Would like to know a simple method, if possible, to import web data into an excel sheet. and then filter There is some information available including use of arrows to select columns needed etc. but do not go through Thank you

how to relate a particular cell in an excel sheet with a value given at a specific location in a web data base

in a worksheet suddenly two cells appear not to have any text although i know it is there what can i do to make the text visible thanks