Searching a cell value for a Character

**dsexpress** · 04-28-2008, 08:46 AM

Hi all,
Thanks for all the help so far. I have a final challenge for my program.

I want to test a cell for the type of value as 678/256 or 345/872/098/987 etc. The common character in each would be the "/". First, I need to check the cell for this, then take the first number and compare it to an integer(if it is <> , or = to). I hope I am clear with my situation. All help is welcomed

**NBVC** · 04-28-2008, 09:06 AM

You mean something like:

=IF(ISNUMBER(FIND("/",A1)),IF(LEFT(A1,FIND("/",A1)-1)+0=B1,"ok","not ok"))

where A1 contains original code and B1 contains number to compare to.

**dsexpress** · 04-28-2008, 09:34 AM

Thanks,
I can play with those statments. what I am looking for is something like:

If cells(i,"G").value contain "/" then flag=1
If flag=1 then retrieve "first number" of value as integer

**NBVC** · 04-28-2008, 10:01 AM

If you were looking for a VBA solution, you should've posted in the Programming forum...

We'll see if someone with VBA skills will join and add a suggestion.

**dominicb** · 04-28-2008, 11:05 AM

Good afternoon dsexpress

For clarification - are you wanting to extract each number from the string in a cell?
What are you hoping to compare them to?

DominicB

**dsexpress** · 04-28-2008, 11:11 AM

I just want to get the first number: eg

289/345/896 result would be integer 289
23/45 " " integer 23
684/234/123/456 ' '' integer 684

I am then comparing this value to a sum of numbers in a collection of cells

Thanks