Forum Discussion
artemkhorew
Jun 17, 2022Copper Contributor
Please help me with formula in Excel
Hi! Help me please. Its very important for my work.I need to make a formula in excel that will return the desired value if it finds only part of a word in a cell, not the whole word.
I need a formula that works like this: if a cell contains "dav", then print "David", if a cell contains "mar", then print "Maria".
This formula looks for different values in the same cell and, depending on which value it finds, print the result
And it has to be 1 formula so that I extend it to all cells
Pls, try help:
https://docs.google.com/spreadsheets/d/17s_P0en1IE8HBgOuIgwj8VZf_TbXEkmp/edit#gid=109711947
artemkhorew OK! You changed the rules a bit. See attached.
4 Replies
Sort By
- Riny_van_EekelenPlatinum Contributor
artemkhorew My Excel didn't like the formulae you had in column B and removed them. In the attached file you will find a working formula in B2, copied down.
- artemkhorewCopper Contributor
Riny_van_Eekelen Hi! The formula does not work for the new conditions 😞 Please look at the file
- Riny_van_EekelenPlatinum Contributor