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 |
Can I search a cell for a value and extract part of content?
Try in N1:
=IF(ISNUMBER(SEARCH("SALES",A1)),SUBSTITUTE(A1,"SA LES","")+0,"") Replace SEARCH with FIND if you need the check on the text to be case sensitive -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Leben" wrote in message ... 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 |
All times are GMT +1. The time now is 02:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com