Add two spaces to positions in cell

[PeteABC123]

Have cells that look like this: WD280457713266


Want to add 2 spaces on the right to make them look like this: WD28045771 32 66


Any thoughts as to a formula?

Thanks for ideas.

Pete

[Fluff13]

If your strings are all the same length, try

Please Login or Register  to view this content.

[AliGW]

Are all entries the same length? If so:

=LEFT(A1,10)&" "&MID(A1,11,2)&" "&RIGHT(A1,2)

[PeteABC123]

Thank you all so much. They do differ in length, but the shorter ones. . .there's only a few. I can just retype those.

Thanks again.

Pete

[AliGW]

There are ways to automate it. Try this:

=LEFT(A1,LEN(A1)-4)&" "&MID(A1,LEN(A1)-3,2)&" "&RIGHT(A1,2)

[Fluff13]

For all lengths try

Please Login or Register  to view this content.

[AliGW]

I think there's an echo in here ...