Biology, asked by iqbalgahla3181, 1 year ago

excel formula for valuie with saparated by comma from cells

Answers

Answered by Anonymous
0
Every time you enter text into a cell it longs to be on one line ... can insert more than one line into one cell on your Excel  ...
Answered by rosey25
3

Answer:

Select a blank cell, enter formula =IF(ISNUMBER(SEARCH(123,A2)),"yes","no") into the Formula Bar and then press the Enter key. See screenshot: Note: in the formula, A2 is the cell contains the comma-separated values you will find.

Similar questions