Notifications
Clear all
General Excel Questions & Answers
3
Posts
3
Users
0
Reactions
79
Views
Topic starter
I need a formula that can refer to a text range... if the cell A5 has a "W4", or "W5", or "W6" all the way up through "W16", then return "6", if it is "W18" pr above, return "7"
can it be done?
thank you for your help!!
Katherine
Posted : 10/10/2020 2:51 pm
Hi Katerine
If the first part of 1 character will always be ignored you can go with =IF(MID(A5,2,999)+0<=16,6,7)
The MID extracts the number, the plus zero makes the text number into a proper number then its just an if which can be adjusted as required
Purfleet
Posted : 10/10/2020 6:49 pm
Hi Katherine,
Another way :
=IF(RIGHT(A5,LEN(A5)-1)+0<=16,6,7)
If you want to retrieve all the characters of a cell except the first one, you can use this combination : RIGHT + LEN.
BR,
Lionel
Posted : 13/10/2020 12:20 am
