I need to search a line in a worksheet (across multiple columns) for a PO number then deposit/copy that number in a new cell (on the same line)
All the PO numbers have set naming conventions like begins with P and is 5 characters long (P****). but the cell could have other characters before or after it (like PO# P***** or 586847/P*****)
So in plain english I want it to search A1:D1 find P***** and if it finds P***** put it in E1.
Can someone help me! Right now we are doing this for 1,000s of lines of data manually!
Thanks!
Jane
Bookmarks