Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Friday, 20 October 2017
  1 Replies
  8.7K Visits
0
Votes
Undo
Is there a function in Kutools that will identify (preferably) or remove duplicate values (but leaving 1 x original value if removing duplicates) in a semicolon separated cell in Excel? My list is @ 150k rows, the cell with the values varies in length between approx. 15 to 65 values.
Example of the cell:
1;27;74;17;79;7;51;4;83;81;47;48;65;60;15;49;5;75;64;62;13;12;45;36;73;44;34;91;90;69;56;54;59;20;46;52;40;58;2;85;78;53;88;1
In this example i need to either identify the first & last values (1) or remove just one (the last one preferably).
Thanks!
Carl
6 years ago
·
#1264
0
Votes
Undo
Hello,
There is no such function for your operation in the Kutools for Excel now.
  • Page :
  • 1
There are no replies made for this post yet.