Results 1 to 6 of 6

Split Column at comma

Threaded View

  1. #1
    Registered User
    Join Date
    02-14-2008
    Posts
    8

    Split Column at comma

    Would there be a formula for splitting a line like the following into separate cells:
    rear handle assy, replaces 20870-65100, 20870-65101, 20870-65102
    Below is what I want it to look like: (COL indicates column separators, for example only, not to be used)
    Instead of:
    (COL1) rear handle assy, replaces, 20870-65100, 20870-65101, 20870-65102
    Should be:
    (COL1) rear handle assy (COL2) replaces 20870-65100, 20870-65101, 20870-65102
    Basically, the formula could define the separating point by splitting "replaces" and everything after that into a new column. PLEASE NOTE that the comma after "assy" has been removed in the finished example...that's how I want it, if possible. I don't want that first comma there after the line has been split.

    Thanks in advance, I appreciate any help very much, as I'm an Excel novice.
    Last edited by KarambaStar; 04-10-2008 at 09:10 PM.

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