LinkBack URL
About LinkBacks
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.
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)
Posting Permissions
Register To Reply
Bookmarks