hello all..
plz find attached in column A i want to remove first 0 and - dash only from numbers..... when i drag the formula those numbers which are already do not have 0 & - remain its same.
regards
hello all..
plz find attached in column A i want to remove first 0 and - dash only from numbers..... when i drag the formula those numbers which are already do not have 0 & - remain its same.
regards
show the result in your file.
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.
can not understand tour answer
Maybe this.....
In B1
and copy down.Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
=SUBSTITUTE(if(left(A1,1)="0",right(A1,len(A1)-1),A1),"-","") and drag down.
My bad.
You only need this.....
In B1
and copy down.Please Login or Register to view this content.
thnxs sktneer..
thnx.its working too
You're welcome gondal! Happy to help.
If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Please add to who you are replying, since you get several answers of several forummembers.Please Login or Register to view this content.
already done solved...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks