I am in the process of trying to write a formula that enters in a store number into a string of 0's. There should always be 8 digits at the end of the hostname.

Ex. store number = 111
hostname should look like wsw2-00000111

Ex. store number = 2222
hostname should look like wsw2-00002222

Ex. store number = 33333
hostname should look like wsw2-00033333

My attempt failed- =IF(LEN(A3)=3,"wsw2-00000XXX",=IF(LEN(A3)=4,"wsw2-0000XXXX",IF(LEN(A3)=5,"wsw2-000XXXXX"

Any help would GREATLY appreciated!