Forum Discussion

artemkhorew's avatar
artemkhorew
Copper Contributor
Jun 17, 2022
Solved

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

 

4 Replies

Resources