Sunil99580
New Member
- Joined
- Dec 21, 2017
- Messages
- 10
Hey,
I have a query regarding Replace multiple spaces within a text with single Space.
I have text within a cell where I have multiple spaces between to characters, I want to replace those multiple spaces with one space only.
Does anyone have a formula for that??
Exp: before - I am Sam Peter.
After- I am Sam Peter.
Thanks,
Sunil
I have a query regarding Replace multiple spaces within a text with single Space.
I have text within a cell where I have multiple spaces between to characters, I want to replace those multiple spaces with one space only.
Does anyone have a formula for that??
Exp: before - I am Sam Peter.
After- I am Sam Peter.
Thanks,
Sunil