I need to insert 2 blanks into some data ,,, e.g. 0001234, I want it to be
able to see 000 1234. Can anyone help?
I need to insert 2 blanks into some data ,,, e.g. 0001234, I want it to be
able to see 000 1234. Can anyone help?
John Moore wrote:
> I need to insert 2 blanks into some data ,,, e.g. 0001234, I want it
> to be able to see 000 1234. Can anyone help?
Lots of unanswered questions here!
If the data is always 7 characters then you can do:
=LEFT(data,3)&" "&RIGHT(data,4)
If you always want to insert after the first 3 characters do:
=LEFT(data,3)&" "&MID(data,4,LEN(data))
I could go on depending on what exactly the requirements are (e.g. put the
blanks before the last 4 characters).
Also this presupposes that you wish to do this using a formula and then
maybe use copy and Paste Special->Values to replace the data. You might want
a macro to do it.
Let us know if the above is not spot on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks