Space between numbers and text

%3CLINGO-SUB%20id%3D%22lingo-sub-1324359%22%20slang%3D%22en-US%22%3ESpace%20between%20numbers%20and%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1324359%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20want%20a%20space%20between%20letter%20and%20numbers%20for%20NI%20numbers%20%3CSPAN%3Eusing%20number%20format%20in%20excel.%3C%2FSPAN%3E%20%26nbsp%3B%20From%20JS123456K%26nbsp%3B%20to%20JS%2012%2034%2056%20K.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1324359%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1324414%22%20slang%3D%22en-US%22%3ERe%3A%20Space%20between%20numbers%20and%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1324414%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F630644%22%20target%3D%22_blank%22%3E%40Ace_Gooner%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20guess%20that's%20repeated%20question.%20You%20can't%20apply%20custom%20number%20format%20to%20text.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I want a space between letter and numbers for NI numbers using number format in excel.   From JS123456K  to JS 12 34 56 K.

1 Reply
Highlighted

@Ace_Gooner 

I guess that's repeated question. You can't apply custom number format to text.