One more step in the Formula Please

S

Steved

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.
 
D

Dave Peterson

Maybe...
="E" & REPLACE(C1125,1,1,"")+0


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.
Click to expand...
 
T

T. Valko

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.
 
S

Steved

Excellent

Thankyou.

T. Valko said:
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.
Click to expand...
 
Top