I have a excel sheet which contains both alphabets and numbers, i want to select those cells which contains any of alphabets from A-Z
I have a excel sheet which contains both alphabets and numbers, i want to select those cells which contains any of alphabets from A-Z
Where have you mocked up your expected results? Are you still using Office 2007?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
in B1
=ISNUMBER(SEARCH(CHAR(ROW(INDIRECT("1:26"))+64),A1))
Enter with Ctrl+Shift+Enter
will give a TRUE/FALSE answer
Last edited by JohnTopley; 06-06-2021 at 03:20 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks