Add text to a cell with text already in it

[Karl0011]

I have a long list of various part numeber and I need to:

Add a 0 (zere) the front of any 4 digit number and then a (dash) "-PWR" at the end.

7170 add 0 and -PWR: 07170-PWR
7165 add 0 and -PWR: 07165-PWR
06175S add -PWR: 06175S-PWR
06152S add -PWR: 06152S-PWR

Thanks,
Karl

[vgr]

ah that's pretty simple suppose your digits are in column A put this formula in column b
=Text(A1,"00000")&"-PWR"
and then fill it down to the end.

[newdoverman]

This will do what you want but if the number is less than 4 digits will only add the -PWR and not the 0

Please Login or Register  to view this content.

[sktneer]

Or simply this.....

Please Login or Register  to view this content.

[Karl0011]

Thanks that worked.

[newdoverman]

Thank you for the feedback. Glad that you have a solution.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.