Add a letter "E"
Hello Peo from Steved
I thankyou.
"Peo Sjoblom" wrote:
="E"&REPLACE(C1170,1,1,"")+0
--
Regards,
Peo Sjoblom
"Steved" wrote in message
...
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.
|