Excel help- splitting one column into two

[Dudd]

I'm doing some data entry here at work, and basically ripping most of the data from another online database, then pasting that info into excel and formatting it to fit the specifications of the new database. The only problem I'm having is that some of the info I'm getting from the internet is listed like this: John Smith and Jane Smith. This is all listed in one column in excel. They want this put into two seperate columns, and I'm having trouble figuring out how to write a macro that will seperate the text into two columns, obviously seperated by the and. The people here who might know how to do this are out for the day, so I'm turning to you guys for help, since many of you seem to be versed in Excel. Just one thing to take into consideration: this is really the first time I've used Excel, and I don't anything about VB (although I do know a fair amount of C++, the different terminology might throw me off). So, could someone help me write a macro that would help me get over this little problem? Thanks a bunch.

 

[oog]

Use the built-in functionality in the Data menu. I think it's called "Data | Text to Columns...". It will allow you to split text based on either a delimiter (like the space) or by position (e.g., the fourth character). Be sure that you have empty columns to the right of the one you are splitting to contain the new values.

 

[Dudd]

Thanks a lot, that did it. I just had to replace all the ands with &'s, and then split it using that character. Much easier than a macro.