Hello Peo from Steved

It works for what I'd required no VALUE error?

Cheers

"Peo Sjoblom" wrote:

VALUE error?

--


Regards,


Peo Sjoblom


"Dave Peterson" wrote in message
...
Maybe...
="E" & REPLACE(C1125,1,1,"")+0



Steved wrote:

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.

--

Dave Peterson