Excel - search for specific text in a row then copy and paste that value into a specific cell

Question

I need to search each row of a spreadsheet for a mac address with format **:**:**:**:**:**

I want to search cells h3-z3 for a mac address and when found copy and paste the mac address into g3

Once I have the formula for one row I will fill down for all rows of the spreadsheet

Help is greatly appreciated!

Answer 1

Use INDEX/MATCH with wildcards:

=INDEX(H3:Z3,MATCH("*:*:*:*:*:*",H3:Z3,0))