Custom Format With Space

[cool1_boy1]

User enters text into a cell such as: T2K5G1.
I want the custom format to convert that to: T2K 5G1.
So it's the same thing with just a space in between.

I tried 000 000 in the custom format but that didn't work. Suggestions?

 

[shg]

Custom formatting applies to numbers, not text. You would need to use VBA, or a formula in another column.

 

[cool1_boy1]

I really didn't want to go that route but I guess I have no choice. Thanks.

 

[shg]

You're welcome.