I have an Excel spreadsheet with 1600 rows of data. I need to create usernames from the first and last names of everyone in the list. I can manually go through and get the first letter of their first name and combine it with the last name to create one, but I am wondering if there is a way to automate it in Excel. I tried concatenate but it appears to be all or none as far as combining values goes. I am hoping there is someone that knows how to do this.