How to delete all zero & space from left side of a particular data with the help of macro
i have data like below
000000000000 010080023000
i want as 10080023000
Again i have like this
000000000000 200000000008
i want like 200000000008
000000004000 000000000000 = 4000000000000000
00000000E000 000000000000 = E000000000000000
000000000020 000040000000 = 20000040000000
i have lots of data like above in the range (D:J).
Please upload sample data.
Also check if the below is helpful.....
Assuming data is in D1 enter formula =TEXT(SUBSTITUTE(D1," ",""),"0")
Last edited by nested.if1@gmail.com; 02-01-2013 at 03:33 AM.
Select the range then run the code
Please Login or Register to view this content.
Here, try this:
Formula:
Please Login or Register to view this content.
Never use Merged Cells in Excel
Or
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thanks all , both macro & formula are working fine...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks