One more step in the Formula Please

  • Thread starter Thread starter Steved
  • Start date Start date
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.
 
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...
 
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.
 
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...
 
Back
Top