| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Ignoring letters behind numbers
This funtion works for me, if there are no letters behind numbers
=IF(ISNUMBER(B7),(IF(B74000, VLOOKUP(B7,Sheet1!A2:B263,2), "S")), "S") but some of the numbers have a letter or two behind them, which I want to ignore (eg. 4123HG i want to recognize as 4123).... Any Help? jeremy -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| no row numbers or column letters DISPLAYED | Excel Discussion (Misc queries) | |||
| How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) | |||
| VLOOKUP for a cell with both letters and numbers | Excel Discussion (Misc queries) | |||
| Averaging noncontiguous numbers ignoring zeros? | Excel Worksheet Functions | |||
| Finding Numbers with Cells that also contain letters | Excel Discussion (Misc queries) | |||
Threaded Mode
