trim

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have this number 06CA070014

I want to trim off 06CA07 and leave 0014. Also how do I format the cell to
make sure the 00 are there. I have to have it read 0014 and so on.
Thanks
Cheyenne
 
You'll need to let us know if the rules are more complex than just pulling
the last 4 characters from the cell....

A1: 06CA070014

B1: =LEFT(A1,4)
returns 0014

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
I don't know if my first post got through....I tried to stop it....

If all you need is the last 4 characters.....

A1: 06CA070014
B1: =RIGHT(A1,4)

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Guaranteed to be 'accepted' if there's a typo in it! <g> Heaven only knows
how many times I wish we had an 'edit' feature in here!
 
That's the truth...There are times I have to fight the impulse to dive out
the window and put a kink in the wire to stop the submission!

***********
Regards,
Ron

XL2002, WinXP
 
Back
Top