How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Jason Jones Your Own Question
Jason Jones
Jason Jones, Computer Technician
Category: Microsoft Office
Satisfied Customers: 16418
Experience:  Over 10 years work experience.
Type Your Microsoft Office Question Here...
Jason Jones is online now
A new question is answered every 9 seconds

how do you change a column in excel that has two values seperated

This answer was rated:

how do you change a column in excel that has two values seperated by a comma into two seperate columns?


Please, do not forget to click the Happy face on the bottom of this page and click Submit, if you are satisfied.

You can do so by following the instructions below:
- Click the top column header (A, B, C, etc) to select the whole column
- Click the Data tab
- Click the Text to Columns button
- Choose Delimited
- Click Next
- Place a check in the Comma field
- Click Finish

Please, keep me updated on the status of your problem if there are any further issues. I will be available to respond.

Please, bookmark the following page if you ever want to work with me directly. Any new questions posted at the following page will be sent directly to me:

Thank you,
- Jason

Jason Jones and 3 other Microsoft Office Specialists are ready to help you