| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I need cell in A not #VALUE!
-- A B Time to Speak #VALUE! Express Messenger 8,000 Express Messenger Spicegirl Kosmos #VALUE! Buffle Head 12,000 Buffle Head Sea Urchin Hanover #VALUE! Pinstripe Pinup 6,000 Pinstripe Pinup Flanery Hall #VALUE! Bound to be There 8,000 Bound to be There LEFT(C14,FIND(",",C14,1)-3) Is there a way to stop the #VALUE! ISERROR did not work LEFT(ISERROR(C14,FIND(",",C14,1)-3) Thank you Esau |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
