lastname

I have an exported excel file from MS ACCESS that is fine but some don't have email addresses, But they are all the same that is, Lastname. (put in a '.')Firstname@dcf.nj.gov How can I make a formula that will do this? Data Lastname Firstname email Smit Joe currently...

I'm sure this has been asked before - if so please direct me. I have Fields: LastName,FirstName,Spouse,Position,Spouse Position It's a list that also includes people that are singles. Just looking for direction how to keep my original list AND elsewhere to have a list that derives and splits...

I am using the VBA below to try to update the FirstName, LastName and MiddleName to a table. Everything seems to be working except when I try to write the string values to the record set. Any ideas why this is not working? Option Compare Database Private Sub parseNames() Dim dbs Dim qdf...

Hi All Need help her to find some formulas til split up a cell and into 2 cells. Got thousands of row to edit. Data i got in column A is set up randomly, Lastname, Firstname Lastname, Firstname Middelname Lastname, Firstname Middelname Middelname Firstname Lastname Firstname Middelname...

I'm using the following to convert Application.Username which is formatted "Last, First" to "First Last". For my name, it is working, but for a colleague it is not. I am baffled. The result for my colleague is "h, John Smith". I have had her select all and retype it, and it's still not working...

Hello everyone, I need to extract the FirstName from cells in a particular format LastName,FirstName MiddleName1 MiddleName2 Note that LastName,FirstName has no space in between, only the comma so I adapted a formula I found on google to: =MID(A10,SEARCH(",",A10,1)+1,SEARCH(" ",A10,SEARCH("...

I have a list of names in column "N" that look like "LastName, FirstName". How to I switch the data in the cell so it looks like "FitstName LastName"?

Good Afternoon, I have a spreadsheet with names in column b (Lastname, Firstname or Lastname, Firstname Middlename or Lastname, generational suffix Firstname or Lastname, Firstname MiddleInitial ) I am needing to create a VBA code to rearrange the names and remove everything except for...

I have a report that shows people names First Name Lastname (Dept) I have a different system that needs people as Lastname, Firstname (Dept) - if applicable. Note - not everyone has their dept name. Just if there is more then one person at the company with the same name. I've found formula...

I have a sheet that contains Email metadata. The data looks like this: https://ethercalc.org/houk0a1zt3 The end goal is to take an email header that looks like: LASTNAME, FIRSTNAME[FIRST.LAST@example.com] And convert it to only: LASTNAME, FIRSTNAME. Problem is that there are many different...

I'll simplify the problem I'm having with an example. I have 2 sheets the first (called CLIENTS) has FIRSTNAME, LASTNAME, COMPANY, TYPE, STATUS The second (called JOBS) has FIRSTNAME, LASTNAME, COMPANY, TYPE, SITE, POSTCODE The idea is that the first sheet is filled in with clients and in the...

The old Roster file had Column "B" = Lastname Column "C" = firstname. <tbody> GHIN # Last Name First Name 1910534 Smith Bob </tbody> The new file has Column "B" = lastname, firstname. <tbody> GHIN # Name 1910534 Smith, Robert </tbody> We want to use the new format so we don't have to...

Hello I just like to pick your brain. I have a column which has the firstname and lastname (one space between them). I want a new column which has the "lastname, firstname". One way I am thinking of is to use Text-to-Columns to separate the firstname from the lastname, then I will use...

HI I am importing data where the name is one column and in this format: Lastname,Firstname I would like to have one column for First name and one for last name. Can I do this in a macro?

Hello, I have a huge list of leads and have the names segregated as First Name and Last Name. However, in some cases, the names have been switched. For e.g.: Some of the records have correctly placed the lead name 'John Smith' as John under First Name column and Smith under Last Name column...

Hey everyone, I've got this really irritating problem. I work in payroll so obviously I'm dealing with lots of employee data all the time. Anyway, whenever I create a pivot table that has surname, forename etc. the pivot table always pushes people with a surname such as May or April to the top...

I have a bunch of names in the following format. Each name is in it's own cell All of them have {First name> S- > Last name} Example: Jane S-Doe I would like it to be: {S- > Last name, > First name} Example: S-Doe, Jane Is there a way to do this automatically with a formula or macro?