Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or
×

semicolon separated values in a single cell

More
1 year 6 months ago #149 by Qiu hongkun
Replied by Qiu hongkun on topic semicolon separated values in a single cell
Hello,
There is no such function for your operation in the Kutools for Excel now.

Please Log in or Create an account to join the conversation.

  • Carl Barton
  • Topic Author
  • Offline
  • New Member
  • Nouveau membre
More
1 year 6 months ago #146 by Carl Barton
semicolon separated values in a single cell was created by Carl Barton
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

Please Log in or Create an account to join the conversation.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Moderators: jaychivoJay Chivo