I have a large list of account numbers where a zero has been added to the end of each number. Example 123 is now 1230. how can I delete remove the ending zero from each account on this list? thanks
I have a large list of account numbers where a zero has been added to the end of each number. Example 123 is now 1230. how can I delete remove the ending zero from each account on this list? thanks
divide by 10? put 10 in a spare cell copy select range of no's paste special divide
or try text to
columns fixed width
put a break before the last digit
click next
change options for the bit with last digit in to do not import column(skip) click finish
Last edited by martindwilson; 01-15-2013 at 05:50 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
DutchEnglischPlease Login or Register to view this content.
and drag downPlease Login or Register to view this content.
And if the result should be a number, you can use this one
EnglischPlease Login or Register to view this content.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks