Thread: Add a letter "E"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
  
Posts: 3,268
Default Add a letter "E"
="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.


Reply With QuoteReply With Quote