Thanks Guys !!

I had tried to get istext to work, but I'm not that great at combining the
functions, I was mistakingly placing the = before istext . . . =if(=istext

I loved the reverse the argument advice. That actually ended up solving
another issue I didn't even know I had.

Both comments were Great!

Thanks so much,

Jim

-------
-------




"Russell Dawson" wrote:

Fred

That's what I was after. I was trying to put IF and ISTEXT together but
not in the correct manner but the not so sophisticated answer I gave appears
to have been sufficient for Jim's purpose.

I much prefer yours for being more succinct.


--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Fred Smith" wrote:

If you are looking specifically for text, you can use the istext function,
as in:
=if(istext(a1),"+","")

Regards,
Fred

"Jim D." wrote in message
...
Hi,

I'm trying to convert the following statement . . . =if(A1=______ , "+",
"")

to . . . a search for any text, that might happen to be in cell A1.

I don't know what the best option is for filling in the blank after A1=


Thanks So much hor helping me if possible,

Jim


.