Hello everyone,
I do not invent (or I do not know Excel well) functions that make my life easier.
It is necessary to insert the symbol "0" in a certain place of the cadastral number. The difficulty comes from the fact that the numbers are not of the same length, i.e. you need to insert a different quantity "0".
Like this:
9584/0005:12 ---> 9584/0005:0012
9552/0001:9 ---> 9552/0001:0009
6899/0002:194 ---> 6899/0002:0194
Can anyone help with formula?
Welcome to the forum.
This will do what you are showing:
=LEFT(A3,FIND(":",A3))&TEXT(MID(A3,FIND(":",A3)+1,4),"0000")
For your locale:
=LEFT(A3;FIND(":";A3))&TEXT(MID(A3;FIND(":";A3)+1;4);"0000")
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
You're a PRO
Thank You very much !
No problem.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks