Get instant live expert help on if cell contains text then

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

i need help conditioning cells in a If cell A1, sheet1 contains "text-x", then cell A1, sheet2 fills cell w/ A2 sheet1's quantity.
Solved by S. Q. in 26 mins
please help populate column contents of 1 of 7 options. The formula should look in a single column for the digit 1,2,3,4,6 or it should understand that it is "blank". It should then populate with the contents of different columns accordingly. For example if it contains 1, should print text from cell A1, if its 2, B1, etc Actual references are: If K3 contains 1, print text of AH3 in AG3 If K3 contains 2, print text of AI1 in AG3 If K3 contains 3, print text of AJ1 in AG3 If K3 contains 4, print text of AK1 in AG3 If K3 contains 5, print text of AL1 in AG3 If K3 contains 6, print text of AM1 in AG3 If K3 is blank, print text of D3 in AG3
Solved by X. Q. in 28 mins
If cell A1 contains value "xyz", I want cell A2 to require text be entered by user. If cell A1 contains anything other than "xyz", I don't need text entered into cell A2. How do I do this?
Solved by C. H. in 20 mins
Goal: If "Type" contains "RSL" or "RML" then copy "Full Name" from start of text to "-"
Solved by F. Q. in 13 mins
I NEED A GOOGLE SHEET FORMULA TO USE AN IF FUNCTION FOR EXAMPLE IF A CELL CONTAIN S ANY TEXT AT ALL THEN ANOTHER CELL POPULATES A NUMBER AND IF THE NEXT CELL IN THE SEQUENCE CONTAINS ANY TEXT AT ALL IT WILL THE SAME NUMBER AGAIN IF ANY CELL IS BLANK IT ENTERS NOTHING AND JUST LEAVES THE OTHER CELL BLANK
Solved by O. C. in 11 mins