Hi I am new to this forum and am hoping some one can help please.
I have alot of data that I need to find certain references within, all this reference are typically around 15 characters long but all start with "0062000" and they contain both numerical and alphabetical characters. I need a formula that will search the whole spreadsheet and locate the references then once it has copy the reference into a new cell/column.
Is this possible, can anyone help please?
Any advice greatly received.
Thanks
Liz
Bookmarks