Transferring Exported Data in One Column into Multiple Columns

[shejna]

Hello,


I have a problem. I am trying to do a VLOOKUP from one workbook to another but I have all my data in one of the workbooks in one column. I work with Schwab and when I export their data it all shows up in column A with commas seperating the data instead of being broken out into individual columns. I need all this data in separate columns. Is there a way to do this? The VLOOKUP portion of this is not important to the solution just as long as there is a quick way to put the data in their own columns.


Thanks!


Sean

 

[shejna]

Well it looks like I figured it out on my own. Kind of embarrassed for even asking that question now.