Is it possible to change a value with letters and numbers?

[Phunshelly]

I need to change a cell format from U1-1-1 into U001-0001-0001 but every row has a differant number.For example:
U2-2-2
U2-3-2

Any help would be greatly appreciated.
Thank you

 

[Dannyh1]

Hi,

Are the number of digits always they same?

Could try:

=LEFT(A1,1)&"00"&MID(A1,FIND("-",A1)-1,1)&"-000"&MID(A1,FIND("-",A1)+1,1)&"-000"&RIGHT(A1,1)

 

[Phunshelly]

Unfortunately no. there are 3 formats:
P8-1-101

P4-C3-3-24

P1A-1-1
Is there a find and replace I could use? find a specific pattern and add the 0's to make each set of numbers between the dashes 4 digits?

Thank you for your time.