jlbecker67
New Member
- Joined
- Mar 26, 2002
- Messages
- 8
I have some cells that have a leading space in them and I want to remove the space. How do I accomplish this without searching all the cells?
Thanks,
Jerry
Thanks,
Jerry
On 2002-03-28 14:49, jlbecker67 wrote:
I have some cells that have a leading space in them and I want to remove the space. How do I accomplish this without searching all the cells?
Thanks,
Jerry
On 2002-03-28 15:06, Bob Umlas wrote:
Edit/Replace; replace " " (without quotes) with "" (without quotes)
Bob Umlas
Excel MVP
On 2002-03-28 14:49, jlbecker67 wrote:
I have some cells that have a leading space in them and I want to remove the space. How do I accomplish this without searching all the cells?
Thanks,
Jerry