Hi, new to advanced editing in Excel so all help welcome.
I have a cell that contains some codes, followed by a reference
e.g.
#AB123;#1234;#AB124;#1235
I want to return the following;
AB123; AB124
so I need to remove the '#' and the 4 digit number where an AB is not present first.
Any help would be great
Cheers
Chris
Bookmarks