I have a data sheet in column B where I need to extract specific word SADC in column B to columns E
Looking a formula to extract the word sadc from column B to E
I have a data sheet in column B where I need to extract specific word SADC in column B to columns E
Looking a formula to extract the word sadc from column B to E
This should do it...
=IF(ISNUMBER(SEARCH("SADC",B2)),"SADC","")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Under the Data Ribbon, there's an "Advanced Filter" option. I am only giving you an example with a screenshot in the file of the criteria I used. It should be self-explanatory, you can mimic the logic and apply to your use case. Just make sure your column header names are all unique.
I'm not sure what you mean by extract?
Replace SADC?
Formula:Please Login or Register to view this content.
If you want to see if something has SADC then
Formula:Please Login or Register to view this content.
Try this
Enter in E2 and copy down
Formula:Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks