Hi All
Is there a way that I can take a cell value and replace the first two characters with two new characters., for example my current value is 04XXXX and I would like to replace the 04 with 05XXXX, however I cant use the find and replace feature because the XXXX part of the contains 0's aswell and it wants to change them aswell!! I have one column with about 5k rows.
Any help would be much appreciated.
Kind Regards
Peter
Is there a way that I can take a cell value and replace the first two characters with two new characters., for example my current value is 04XXXX and I would like to replace the 04 with 05XXXX, however I cant use the find and replace feature because the XXXX part of the contains 0's aswell and it wants to change them aswell!! I have one column with about 5k rows.
Any help would be much appreciated.
Kind Regards
Peter