Insert Blanks

[Guest]

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?

 

[Paul Lautman]

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.