Hello
I want know a formula, where it should be like below:
If the cell contains "ACT" or "TERM" or "LOA" then it should change to "A" or "T" or "L"
If the cell contains "-", then it will change to "NULL"
Please help.
Hello
I want know a formula, where it should be like below:
If the cell contains "ACT" or "TERM" or "LOA" then it should change to "A" or "T" or "L"
If the cell contains "-", then it will change to "NULL"
Please help.
Last edited by AliGW; 12-15-2018 at 02:21 AM.
Multiple ways of doing this. You can make a table and do a simple vlookup formula or you could use this formula assuming ACT TERM or LOA are in cell A1.
Also this is assuming that "-" is a hyphen and not 0.
=IF(A1="-","NULL",LEFT(A1,1))
Welcome to the forum!
Please note that your thread title was inadequate so I have changed it for you this time. In future please provide thread titles that tell us something of the problem you are trying to solve.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks