Hello,
I am searching for a formula that will print a certain string of text in a cell, example below:
A2
4P6.6
B2
4P6.6
So I need a formula that will search a cell (A2) for the certain word I specify and then the print that word (B2).
Hello,
I am searching for a formula that will print a certain string of text in a cell, example below:
A2
4P6.6
B2
4P6.6
So I need a formula that will search a cell (A2) for the certain word I specify and then the print that word (B2).
Last edited by spudder6; 12-19-2018 at 01:13 PM.
Try this in B2:
=IF(COUNTIF(A2,"*4P6.6*"),"4P6.6","")
Based on what you have shared, this formula will search for "4P6.6" in A2 and if it finds it, it will return "4P6.6" in B2.
If "4P6.6" is not found in A2, B2 will return blank.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks