Results 1 to 4 of 4

Separate data at commas

Threaded View

  1. #1
    Registered User
    Join Date
    07-03-2008
    Location
    Sweden
    MS-Off Ver
    Office 2011 for MAC
    Posts
    57

    Separate data at commas

    Hi,

    I've imported a large document to excel. It contains 118 rows of information. My problem is that all the information is in column A. Every cell contains long sentences with information. The information is divided by a comma-sign (,). What i want to do is to seperate the information by columns instead of a commasign. So for example:

    ...A....................................................B....C.....D
    1 Div,Date,HomeTeam,AwayTeam,FTHG
    Becomes:

    ......A....B ........C.............D..........E
    1 Div Date HomeTeam AwayTeam FTHG


    Is there any smart way to do this??



    Thanks for your help guys.

    Best regards,

    Marcus
    Last edited by elmaco12; 11-12-2009 at 04:52 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