Hi all, I was wondering if it is possible to edit cell values like this:
Lets say cell values are following:
400100
401500
410200
448600
4300
Is it possible to simply edit them to be only first three digits i.e:
400
401
410
448
430
Thanx!
Hi all, I was wondering if it is possible to edit cell values like this:
Lets say cell values are following:
400100
401500
410200
448600
4300
Is it possible to simply edit them to be only first three digits i.e:
400
401
410
448
430
Thanx!
Try this
Enter formula in B1 and copy down
[/B]Formula:Please Login or Register to view this content.
v A B 1 400100 400 2 401500 401 3 410200 410 4 448600 448 5 4300 430
Last edited by AlKey; 05-06-2018 at 01:28 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Wow, it works! I was expecting something much more complicated :D
Thank you!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks