Disclaimer: Links on this page pointing to Amazon, eBay and other sites may include affiliate code. If you click them and make a purchase, we may earn a small commission.

Results 1 to 3 of 3

Thread: MS Excel help

  
  1. 07-26-2008, 02:08 PM #1
    scottkoz20
    scottkoz20 is offline



    Join Date
    Apr 2007
    Age
    50
    Posts
    33,159
    SCF Rewards
    20,283
    Blog Entries
    8
    Country
    Cleveland Indians Buffalo Sabres Buffalo Bulls
    See scottkoz20's Items on eBay Packrip.com Traders COMC Cards For Sale Upper Deck ePack
    Send PayPal to scottkoz20 Member is PayPal Verified

    MS Excel help

    Does anyone know how to split the contents of 1 cell into multiple Cells?

    For example, if Derek Jeter is in one cell, can this become Derek in 1 and Jeter in the 2nd?

    Thanks in advance
    Add as FriendAdd as Friend
  3. 07-26-2008, 03:41 PM #2
    john1170
    john1170 is offline



    Join Date
    Mar 2003
    Age
    55
    Posts
    3,112
    SCF Rewards
    400
    Country
    See yoda5's Items on eBay

    Highlight the cell. Click on "Data", then "Text to Columns." Choose the option for "Fixed Width" and click next. Then next again. Then finish. That should do it.
    Add as FriendAdd as Friend
  4. 07-26-2008, 04:29 PM #3
    scottkoz20
    scottkoz20 is offline



    Join Date
    Apr 2007
    Age
    50
    Posts
    33,159
    SCF Rewards
    20,283
    Blog Entries
    8
    Country
    Cleveland Indians Buffalo Sabres Buffalo Bulls
    See scottkoz20's Items on eBay Packrip.com Traders COMC Cards For Sale Upper Deck ePack
    Send PayPal to scottkoz20 Member is PayPal Verified

    AHH!!! sweet!

    This will work for the time being... just need to figure out how to automate that... :)


    Thank you,

    Scott
    Add as FriendAdd as Friend
« Previous Thread | Next Thread »

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

SCF Sponsors


About SCF

    Sports Card Forum provides sports and non-sports card collectors a safe place to discuss, buy, sell and trade.

    SCF maintains tools that will allow collectors to manage their collections online, information about what is happening with the hobby, as well as providing robust data to send out for Autographs through the mail.

Tools and Forums



Sponsors



Follow SCF on