how to isolate data from column?

Hi there,

I have a column with different common names, such as: Server1, Server2, Server3, etc.
I need to extract only the cells containing Server1 to another column, and the rest should remain in blank... How can I achieve this?

Thank you for your time,
Regards.

Assuming your names are in column A, starting in A1, you can put this formula in B1:

=IF(ISNUMBER(SEARCH("Server1",A1)),A1,"")

then copy down as required.

Hope this helps.

Pete

Hi there guys, thank you very much for your help.

Thank you @Pete_UK for your answer, unfortunately (and I know this is a very noob question) I get the error:
"We found a problem with the formula......."

Also, I was wondering, how could I apply a multi-filter?, Place in the same column "Server1" and "Server2", for example. Is that possible?

@Richard Buttrey I've tried this, unfortunately there are some columns where "Server1" is within a phrase... Also, there are more than 10K rows, which makes it quite difficult, and an automated solution would be preferable.

Thank you very much for your time guys, It is highly appreciated.

As you are in Spain, you will probably need to use a semicolon ( ; ) instead of the commas ( , ).

Hope this helps.

Pete

Originally Posted by Pete_UK

As you are in Spain, you will probably need to use a semicolon ( ; ) instead of the commas ( , ).

Hope this helps.

Pete

Thank you Pete!, it worked perfectly!... I didn't know it would be different depending on the language... That explains why CSVs in my version are exported with ( ; ) instead of ( , )

May I ask, would it be possible to look for several expressions and place them in the same column? how could I achieve this?

Thank you very much!

Thank you, just tried that with the expression ServerX number, however, and unfortunately, there are another expressions such as Computer, or Laptop. Which can't be handled with such wildcard.

Any advise?
Thank you very much for your help so far.

Regards.