+ Reply to Thread
Results 1 to 4 of 4

Thread: Dividing text

  1. 03-17-2010, 05:45 PM #1
    shadow91
    shadow91 is offline
    Registered User
    Join Date
    03-17-2010
    Location
    Sebastopol, MS
    MS-Off Ver
    Excel 2007
    Posts
    14

    Dividing text

    So I have these frame sizes in one column.
    Like:
    3x7
    8x10
    14x11
    30x8
    4x10
    5x10

    And what I want to do is have them divided out into two columns
    Like one column with the width, and one column with the height.
    width height
    3 7
    8 10
    14 11
    30 8
    4 10
    5 10

    Is this even possible?
    Reply With Quote Reply With Quote
  2. 03-17-2010, 05:53 PM #2
    shg
    shg is offline
    Forum Moderator shg's Avatar
    Join Date
    06-21-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2007
    Posts
    25,131

    Re: Dividing text

    So easy it will amaze you.

    Select the column, Data > Text to columns, tick Delimited, Next, in the Other box enter x, Finish.
    Microsoft MVP - Excel
    Entia non sunt multiplicanda sine necessitate
    Reply With Quote Reply With Quote
  3. 03-17-2010, 05:58 PM #3
    shadow91
    shadow91 is offline
    Registered User
    Join Date
    03-17-2010
    Location
    Sebastopol, MS
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Dividing text

    Thanks a bunch. That was extremely helpful.
    Reply With Quote Reply With Quote
  4. 03-17-2010, 05:59 PM #4
    shadow91
    shadow91 is offline
    Registered User
    Join Date
    03-17-2010
    Location
    Sebastopol, MS
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Dividing text

    (I really can't believe it was that easy... ha)
    Thanks again.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0