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.=IF(AND(LEFT(A1,1)="0",ISNUMBER(FIND("-",A1))),SUBSTITUTE(RIGHT(A1,LEN(A1)-1),"-","")+0,A1)
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.
thnx.its working too
My bad.
You only need this.....
In B1
and copy down.=SUBSTITUTE(A1,"-","")+0
thnxs sktneer..
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.thnx.its working too
already done solved...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks