Leading zeros plus text

[lenebene]

I am having a problem adding leading zeros to an account. Example:

RTF-123
Should look like this - RTF-00123

RRR-12
Should look like this - RRR-00012

Any help would be greatly appreciated.

Thanks!

 

[SkipVought]

Hi,

I assume that you are CONCATENATING a number with text
[tt]
=YourText&Text(YourNumber,"00000")
[/tt]


Skip,
[sub]
[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount! [/sub]

 

[xlhelp]

I presume Excel is what you are looking for

If your account number is in cell A2, then

=LEFT(A2,FIND("-",A2))&"000"&RIGHT(A2,LEN(A2)-FIND("-",A2))

 

[lenebene]

Sorry. Yes it was excel!

Thank you xlhelp. I was able to get yours to work... I must be brainless today because I couldn't get Skips to work..

Thanks again!

 

[SkipVought]

xlbo's works of you already have the string put together.

Mine works putting the string together from scratch.

Skip,
[sub]
[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount! [/sub]