i want add trailing zero where the length is 8 , before 05 from the right
number len rezult len
1205 4 12000005 8
12305 5 12300005 8
123405 6 12340005 8
1234505 7 12345005 8
i want add trailing zero where the length is 8 , before 05 from the right
number len rezult len
1205 4 12000005 8
12305 5 12300005 8
123405 6 12340005 8
1234505 7 12345005 8
Last edited by sachin483; 12-27-2023 at 06:19 AM. Reason: attached file
For one way, enter the below formula in C2 and copy down
Formula:Please Login or Register to view this content.
BSB
Last edited by BadlySpelledBuoy; 12-27-2023 at 06:38 AM.
Another way,
E2 and copy down.
Please Login or Register to view this content.
Thanks both the formula working fine @windknife & @BadlySpelledBuoy
You are welcome.
--------------------------------------
If that takes care of your original question, please click on "Thread Tools" from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks