I would like to do the following, preferably in one step, otherwise in different steps:
a) Replace all double spaces in all cells in columns B and H until all words in the cells are separated by one space only
b) Remove all commas from all cells in columns B and H
c) Remove all full stops after the last words in all cells cells in columns B and H, but not in other positions in the cells
Would there be a way to do this in Excel?
Thanks,
CA
a) Replace all double spaces in all cells in columns B and H until all words in the cells are separated by one space only
b) Remove all commas from all cells in columns B and H
c) Remove all full stops after the last words in all cells cells in columns B and H, but not in other positions in the cells
Would there be a way to do this in Excel?
Thanks,
CA