Currently Being ModeratedApr 17, 2013 11:16 AM (in response to composerguy78)
Ambiguous question. Will the cell in A contain only a single letter or a string of one or more characters? Should the formula detect only lower case x, upper case X, or be case insensitive?
Here's a general solution:
Formula in all cells in column B: =IF(OR(LEN(SUBSTITUTE(A,"x",""))<LEN(A),LEN(SUBSTITUTE(A,"X",""))<LEN(A)),"X"," ")
Currently Being ModeratedApr 17, 2013 11:33 AM (in response to Barry)
My apologies - ambiguous indeed!
That totally solved it for me! I manged to reverse engineer the formula a bit and it's doing just what I want.