Hi guys,

Need a macro to search for a text string in Column A that can be infinitely long. Normally over 100,000 records. String that I'm looking for is unique as it alwasy is preceeded by '<' in the cell.
I would like the maco to search for the string, which looks comonly like '<COM123-1' or '<123'. Create a new worksheet, in the workbook and list all records, but remove the '<' first.

So results would look like
"
Wkb 2
Col A
COM123
COM123-1
123
"
and so on.

Any help would be greatly appreciated.