Parsing User List

[Johnny Lawndart]

Probably an easy one, but my brains are spent:
Sheet 1 column contains "List of Users" names, last-name-first, with commas.
Sheet 2 has column H: list of user's names (no commas), and N: "Usernames (log-in)".
I'm trying to parse the Usernames from Sheet 2 into a new column in Sheet 1 for each user.
Is it as easy as it sounds? Because I'm just missing it.

Johnny

 

[hiker95]

Johnny Lawndart,

Welcome to the MrExcel forum.

1. What version of Excel, and, Windows are you using?

2. Are you using a PC or a Mac?


I would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


Or, you can post your workbook/worksheets to the following free site (sensitive data changed), and provide us with a link to your workbook:

https://dropbox.com

 

[Johnny Lawndart]

Windows 7, Excel '13, on a PC.

 

[hiker95]

Johnny Lawndart,

I would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


Or, you can post your workbook/worksheets to the following free site (sensitive data changed), and provide us with a link to your workbook:

https://dropbox.com