Search for text and then write value to a cell?

I need to read column and cell A1.
I am searching for a text string. In this case "Acme Inc."
Acme Inc. can be at the beginning, middle or end of the string I am searching.
Acme Inc. can have text before or after it in the string.
Once Acme. Inc. has been found I then want Acme Inc. written to column and cell H1
Then repeart for all of colunm A

I have been trying to use vLookup but with no luck. Here is my syntax.

=VLOOKUP("Acme Inc.",A1:A10,1)

How do I find my text string?
Then, how do I write it to another cell?

Thanks to anyone who can help.

Originally Posted by NBVC

Maybe you mean?

=IF(Isnumber(search("Acme Inc.",A1)),"Acme Inc.","")

copied down

Well that does not generate any syntax errors but it also displays nothing. I am new to Excel coding so sorry for newbie questions. How do I use your code, display the contents and then write the Acme Inc. value to a new cell?

Thanks!!

Originally Posted by NBVC

That is a formula that you would but, in say cell H1, and it looks in the text string that is in A1 and tries to find the exact string: "Acme Inc." (period included). If it does not find that exact string, it returns a blank.. otherwise it returns the text "Acme Inc."

You can remove the period if you want to ignore if a period might exist or not in the search string

Cool......got it. Yes, it does work. Thank you !!!!!