Romulo Avila
04-12-2017, 02:35 PM
Good evening,
I have a spreadsheet where in column B I need to create a formula that sorts the products as follows.
- If it contains the characters "-BC-" or "-CD-" which classifies using the first 02 characters plus the letters;
- In cases where you do not have these characters that search only the first 02 digits;
In case it does not contain the characters, I can use the formula left (a1,2), but in the case that contains the characters I tried to use the formula SEARCH but I could not, I wanted to use only one formula ..
Thank you for your help
18919
I have a spreadsheet where in column B I need to create a formula that sorts the products as follows.
- If it contains the characters "-BC-" or "-CD-" which classifies using the first 02 characters plus the letters;
- In cases where you do not have these characters that search only the first 02 digits;
In case it does not contain the characters, I can use the formula left (a1,2), but in the case that contains the characters I tried to use the formula SEARCH but I could not, I wanted to use only one formula ..
Thank you for your help
18919