Number format with numbers and text

[Issie_52]

Hi,

I was wondering if it is possible to use number formatting to do the preferred option below. I have a lot of codes and have to type the space between the text and numbers.

Any help or ideas will be appreciated.

[TABLE="width: 192"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]GENERAL[/TD]
[TD]PREFERRED[/TD]
[/TR]
[TR]
[TD]DSF485EC[/TD]
[TD]DSF 485 EC[/TD]
[/TR]
[TR]
[TD]HYY454NW[/TD]
[TD]HYY 454 NW[/TD]
[/TR]
[TR]
[TD]HXL853EC[/TD]
[TD]HXL 853 EC[/TD]
[/TR]
[TR]
[TD]FPY691GP[/TD]
[TD]FPY 691 GP[/TD]
[/TR]
[TR]
[TD]HBB190EC[/TD]
[TD]HBB 190 EC[/TD]
[/TR]
</tbody>[/TABLE]

Thank you.

 

[Fluff]

Re: Number format with nummbers and text

You cannot do that with number formatting, but you can do it with macros, if your interested.
Or you can use a formula, but that would have to be in a different cell

 

[Issie_52]

Re: Number format with nummbers and text

Thank you Fluff for replying. Don't want to use a macro but I can work out the formula thanks.

 

[Peter_SSs]

Re: Number format with nummbers and text

.. I can work out the formula thanks.

Could use LEFT, MID & RIGHT but another option is
=REPLACE(A2,4,3,TEXT(MID(A2,4,3)," 000 "))

 

[Issie_52]

Re: Number format with nummbers and text

Thank you Peter! It works and will save a lot of time!

 

[Peter_SSs]

Re: Number format with nummbers and text

Thank you Peter! It works and will save a lot of time!

Cheers. Glad to help.