Results 1 to 7 of 7

Split wordings to different column with a specific format

Threaded View

  1. #1
    Registered User
    Join Date
    10-11-2017
    Location
    Hong Kong
    MS-Off Ver
    2019
    Posts
    57

    Split wordings to different column with a specific format

    Dear all,

    I want to split one column with wordings more than 60 words to two or more separate column. I try to use LEFT, RIGHT, LEN function to do that but the result is not good because it has a possibility to cut a complete words to different column (Column E and F). Is it possible to generate the result just like Column C and D so it can have a better presentation? There would be a space between two words in the format (Column A). Attached excel for your working. Thanks!

    Jack
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Split column/cell on specific text
    By tstackhouse10 in forum Excel General
    Replies: 2
    Last Post: 11-14-2017, 03:27 PM
  2. Split Column into Multiple Columns Based Off Specific Criteria
    By hellzone in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-31-2017, 09:49 PM
  3. vba code to format a column to a specific format (SSSS X1111111)
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-18-2017, 03:16 PM
  4. [SOLVED] Macro to split data onto new sheets based on specific column
    By pauldaddyadams in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-17-2015, 12:53 PM
  5. [SOLVED] Split specific chars in one column to other columns with no delimiter
    By Fjalar in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-21-2013, 12:28 PM
  6. Split data into multiple documents based on specific column
    By v_nastey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-16-2013, 08:56 AM
  7. [SOLVED] How To Split Excel File Into Separate Workbooks Based on Values In a Specific Column
    By UzieJacuzzi in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 07-31-2012, 07:26 AM

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