One more step in the Formula Please
Excellent
Thankyou.
"T. Valko" wrote:
Try one of these:
="E"&REPLACE(C1125,1,1,"")+0
=REPLACE(C1125,1,3,"E")
="E"&RIGHT(C1125)
Which is best depends on what exactly you're trying to do.
--
Biff
Microsoft Excel MVP
"Steved" wrote in message
...
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.
|