Thread: One more step in the Formula Please
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steved Steved is offline
external usenet poster
  
Posts: 519
Default One more step in the Formula Please
Hello from Steved

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

The above will change B009 to 9

What is reqired please is to go one step futher and ask the formula to add E
so that it will show E9

Thankyou.
Reply With QuoteReply With Quote