Hi,
Hoping everybody is doing OK.
I need help with a formula to delete the 7 digit of a list of numbers and after that to delete the duplicates.
The list is long more than 50,0000 lines.
Please see the attachment.
Thanks a lot for your attention in advance.
Manena
In B2 and copy down,
=left(a2, 6)
Then select columns A & B, Data > Remove Duplicates, untick the first column, press OK.
Entia non sunt multiplicanda sine necessitate
Removal of 7th digit
=LEFT(A2,6)
Actually this is removing everything from the 7th digit and beyond but based on your data gives the results you want.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Thank you both.
It works wonderful.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks