Add a letter "E"

[Steved]

Hello from Steved

The below converts B0021 to 21

Question please how can I put the letter "E" in front off the 21 to look
like this E21.

=REPLACE(C1170,1,1,"")+0

Thankyou.

 

[Peo Sjoblom]

="E"&REPLACE(C1170,1,1,"")+0



--


Regards,


Peo Sjoblom

 

[Steved]

Hello Peo from Steved

I thankyou.

="E"&REPLACE(C1170,1,1,"")+0



--


Regards,


Peo Sjoblom