One more step in the Formula Please
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
|