Hello All,
Need help with below situation
I've data available in a cell (say A1) as below:
abc|bcd|xyz|prq|uvw
Iam looking for a logic where I can search list of strings (say bcd or pqr) from A1 and get the matched string (say bcd) as a result in B1 cell (formula to be entered B1).
Need help with below situation
I've data available in a cell (say A1) as below:
abc|bcd|xyz|prq|uvw
Iam looking for a logic where I can search list of strings (say bcd or pqr) from A1 and get the matched string (say bcd) as a result in B1 cell (formula to be entered B1).