excelinexcel7
New Member
- Joined
- Nov 8, 2012
- Messages
- 11
Hi Everyone,
I have a list of 1000 columns where the data is like this:
ABCDEFGHIJKL
DCABHG
ABTGYU
I want to add a space after every 3 characters. Please advise, how can I do this in excel.
So the output should be like this.
ABC DEF GHI JKL
DCA BHG
ABT GYU
Thanks
Jay
I have a list of 1000 columns where the data is like this:
ABCDEFGHIJKL
DCABHG
ABTGYU
I want to add a space after every 3 characters. Please advise, how can I do this in excel.
So the output should be like this.
ABC DEF GHI JKL
DCA BHG
ABT GYU
Thanks
Jay