Hi all
I have a column in excel holding things like
abc
delimiter
def
delimiter
ghi
the 'deimiter' is literally the string 'delimiter'. I need to add a sequence number to each occurrence of the word 'delimiter' in the column, giving something like:
abc
delimiter001
def
delimiter002
ghi
...
delimiternnn
Any ideas?
Thanks
JG
I have a column in excel holding things like
abc
delimiter
def
delimiter
ghi
the 'deimiter' is literally the string 'delimiter'. I need to add a sequence number to each occurrence of the word 'delimiter' in the column, giving something like:
abc
delimiter001
def
delimiter002
ghi
...
delimiternnn
Any ideas?
Thanks
JG