hi all
i need to remove/omit the first digit in a value, however, it would be very tedious to edit them one at a time because there are over 15000 lines in that column.
The first digit happens to be "0" for all values in that column.
Anyone here please help thank you.
(:
Do all values in that column begin with 0 ? If so Select the column with the affected data, select text to columns from the data menu. Select the fixed width option and then select where you want it to be seperated(probably immdediately after the 0), everything after the 0 will then be put in a seperate column.
Let me know how you go!
zomg! you are amazing! thanks!!
It could be your cell formating that is setup to display a set number of digets
Example to display 012345 when the true value in the cel is 12345 the cel would be formatted as 000000.
If changing the formatting does not work try Steel Monkey suggestion or this formula in a blank column
=MID(A1,2,LEN(A1-1))
The copy down
Change cell reference A1 as required
Once formula is entered use copy > Pastespecial > Values
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks