G
Guest
Hi,
In cells c1 to h200 I have long sentences in each cell,
all the letters are in capitals. I need to write a macro
which loops through each cell and changes the letters to small
except:
1)The first letter
2) Any letter after a full stop
3) i
e.g. THE DAY WAS SUNNY AND I WORE A HAT.PETER WAS THERE
Becomes
The day was sunny and I wore a hat.Peter was there
Thanks A Million for any help
In cells c1 to h200 I have long sentences in each cell,
all the letters are in capitals. I need to write a macro
which loops through each cell and changes the letters to small
except:
1)The first letter
2) Any letter after a full stop
3) i
e.g. THE DAY WAS SUNNY AND I WORE A HAT.PETER WAS THERE
Becomes
The day was sunny and I wore a hat.Peter was there
Thanks A Million for any help