| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
trim
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
trim
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 "Chey" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
trim
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 "Chey" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
trim
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! "Ron Coderre" wrote: 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 "Chey" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
trim
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 "JLatham" wrote: 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! "Ron Coderre" wrote: 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 "Chey" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trim and Mid with VBA | Excel Discussion (Misc queries) | |||
| Trim | Excel Discussion (Misc queries) | |||
| Trim help please | New Users to Excel | |||
| trim | Excel Worksheet Functions | |||
| Trim Again | New Users to Excel | |||
Linear Mode
