Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I search a cell for a value and extract part of content?
I want to test a cell using something like a "substring" looking for 5
characters. If I find a match I want to capture an use the 4 postion numeric value in another cell. Example: A1 contains "SALES 4567". I want to test cell A1 for "SALES" and If I find the value "SALES" I want to capture the numeric value "4567" in cell N1. Thanks, JOHN |