Results 1 to 3 of 3

Split members of one cell according to string lenght, cut and paste other column

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-12-2007
    Location
    Germany
    MS-Off Ver
    2007
    Posts
    472

    Split members of one cell according to string lenght, cut and paste other column

    Hello,
    I have got a large wordlist containing over 400 000 words and millions of meanings and explinations. Col. A cotains of words and col. B contains of meanings and explinations(seperated by ";"). Now i want to split column B into two columns. Those members which are longer than 30 Charachters should be cut from col. B and pasted in corresponding cell of column K.
    Please, refer to the attachment as simplified example.

    thank you very much for each assistance in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1