Hi all
I have a string of numbers that return in a cell in the following format:
374:10,4:0,350:0,318:0,227:0,240:0,267:0,264:0,411:0,211:0,49:0,409:0,607:0,315:0
I am basically trying to return the following in an adjacent cell:
374,4,350,318,227,240,267,264,411,211,49,409,607,315
So anything to the left hand side of the colon. Any help you can provide I would be grateful.
Many thanks.
Bookmarks