Looking for specific text Value in cell
Hello. I'd like to look for a specific character or value within a given cell that is part of a larger string of data, but I'm having trouble for some reason. So for example, if the Cell Value = "Hello123" I want to evaluate if the Text "3" exists within the cell. Any help would be greatly appreciated. Thanks. Dan *** Sent via Developersdex http://www.developersdex.com *** |
Looking for specific text Value in cell
With your text in a1 try
=IF(ISERROR(FIND("3",A1)),"Not There","There") Mike which will "Dan Gesshel" wrote: Hello. I'd like to look for a specific character or value within a given cell that is part of a larger string of data, but I'm having trouble for some reason. So for example, if the Cell Value = "Hello123" I want to evaluate if the Text "3" exists within the cell. Any help would be greatly appreciated. Thanks. Dan *** Sent via Developersdex http://www.developersdex.com *** |
Looking for specific text Value in cell
Yes, I have tried that and it works well, but I have a whole string of information I'll need to look for. It makes the formula obnoxiously long, so I was going to go the VBA route instead...unless I'm setting up something wrong in the formula. *** Sent via Developersdex http://www.developersdex.com *** |
All times are GMT +1. The time now is 09:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com