last name

  1. I

    Separate List in Different Sheets Based on ALPHA Rules

    Hello, I have a spreadsheet of 7 columns (A-G) and can have varying amounts of rows (in the 1000's). The first column is a list of client names "LASTNAME, FIRSTNAME." Each employee has a caseload assignment based on the last name of the clients. So one employee has all the "C's" and another has...
  2. T

    Parsing names and Zip code questions

    I do a lot of spreadsheets where the original may have a set up like this Column A: James Doe Jr Jonathan Doe Jr I need it set up with the first name in the first column and the last name and Jr put into the second column. I have tried text to columns but it puts each part of the name as...

Some videos you may like

This Week's Hot Topics