1. P

    Create an email address for all rows that don't have it

    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 '.') How can I make a formula that will do this? Data Lastname Firstname email Smit Joe currently...
  2. L

    List of Names: Extract Address like info into individual row list (eg. Husbands/Wives/Singles)

    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...
  3. J

    VBA script not writing to field as expected

    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...
  4. G

    Excel split cells with full name into 2 columns.

    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...
  5. M

    Application.Username modification not working as expected

    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...
  6. S

    Extracting a middle word in cell without space separation

    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("...
  7. Z

    Transpose data in cell

    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"?
  8. J

    Rearrange names with VBA Macro

    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...
  9. J

    Need help showing department names in ()

    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...
  10. T

    Normalizing Email Addresses/Email Headers

    I have a sheet that contains Email metadata. The data looks like this: The end goal is to take an email header that looks like: LASTNAME, FIRSTNAME[] And convert it to only: LASTNAME, FIRSTNAME. Problem is that there are many different...
  11. D

    Match & Index with specific criteria

    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...
  12. S

    Alternate need for vlookup

    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...
  13. L

    changing the order of a text in a column - lastname, first name

    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...
  14. P

    Create to columns from a name

    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?
  15. S

    Validating First Name and Last Name for Leads

    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...
  16. R

    Excel treating people with the lastname of April or May as months

    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...
  17. G

    I need to change "Jane S-Doe" to "S-Doe, Jane" in the same cell. Help appreciated.

    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?

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back