Hi Guys,
This is my first post since I registered on the forum. Please help.
In the cell I have:
Cell A1: $23.00/6, $25.00/6
Cell A2: $29.50/3, $30.50/3, $31.50/1, $32.50/1
Cell A3: $27.55/3 months, $28.10/1 month, $28.38/1 year, $28.66/1, $28.94/1, $29.22/1
Cell A4: $22.75/2 + $0.75 annual increases
etc.....
I need to get a formula that would show me in cell B1, B2, B3, B4, etc.... True if there is no letters in the cell, and False if there are ANY letters.
I tried to use "ISTEXT(A1).... but it shows me TRUE, because it reads "/" and ";" as text... I need to disregard it..... and have it False when there is any alphabetic letters.
Thanks a lot.
Bookmarks