Excel copy paste formatting

I have a text file with a lot of data. It goes: item number, description, price, total, ect. When i copy pasted the raw text into excel, each line contains all the data in the first cell. Is there a way for excel to place each variable into a different cell? Example: currently it is

  A

1 item number, description, price, total

2 item number, description, price, total

 

I wish to have:

 A.         B.       C.      D.       

1 item number description price total

2 item number description price total

By: Hank

Leave a Reply

Your email address will not be published. Required fields are marked *