surname

Hey there, So I have a spreadsheet right now that looks like this: <colgroup><col span="5"></colgroup><tbody> Name Surname Company Income Address John Smith General Motors 100000 (Address1) Peter Jackson Hilton Hotels 70000 (Address1) Peter Jackson Hilton Hotels 70000 (Address2)...

sheet 1 - I have a first name in 1 box and a surname in another. I then combined them using '&' in a formula, with a space, and pasted values so I now have first name space surname - I then tried to lookup that name in Sheet 2, and bring back a value next to it. My issue I get #n/a as the...

Hi all, I am hoping that somebody can show me the easiest way to accomplish deleting the values in multiple cells from another cell. I thought it would be an easy SUBSTITUTE with "", but nothing I am writing works. It will obviously need a more elegant VBA solution. From the table below I am...

Hello all I am trying all sorts with wildcard and I have not really used advanced filter but am in a muddle trying I have a dataset in a sheet called staff column A has Forename Column B has Surname Column C has staff ID no and Column D has dept I would like in a separate sheet called...

Hi . I have 2 tables , mobile number is the relation shipped data one to many. first table has client data name, surname etc second table has mobile number and visit details i have a form for 2nd table and i put 2 labels . I need when i put the mobile number (afterupdate vba) first label caption...

Hi. I have 2 tables , first has people details , 2nd has these people visit (mob number , name surname there is in both tables and mobile is relationship one to many). I need when in 2nd table i put the phone , name and surname auto filled Thanks

I am trying to extract data from a cell(s) that contains surname, first name, middle name. e.g bloggs, john charles I am just after the surname e.g. bloggs The following formula works well for my data. =TRIM(MID(SUBSTITUTE(SUBSTITUTE($H12020,",","")," ",REPT("...

I have the following formula to extract the name and surname from an email address. I need to amend the formula so that dot (.) does not appear between the name & surname =PROPER(LEFT(B3,FIND("@",B3)-1)) your assistance in resolving this is most appreciated...

Hi I am looking for some help please. only been coding for a few months now and only know basic. I am trying to match two sets of data in different sheets, sheet1 Col A = ref no, B = surname, C = int, etc, the same data on sheet 2. Is there in way using vba to match the data in sheet 1 to...

Hi All, I have a report where I have a customers surname in column B, and then four different email addresses are entered in columns K, L, M and/or M. During a booking journey the same email address can be put into each column, and more than one email address can be put into a column by...

Hello, I have the below text that I would like to extract the person's name (highlighted in bold) who is responsible for "Markup Changes" .. essentially this is the second instance of "responsibility of" Cell text looks like this variable text (Responsibility of: surname, firstname, due...

Hi there, I am working with a pivot table to show the breakdown of users (first name and surname) and the training courses they have completed for our online training program. The problem I am having is that the pivot table is displaying the first name on one row and the surname on another row...

In A1 Sheet 1 I am going to type a first name and surname separated with a space. then in sheet 2- I have a list of first names in column A and Surnames in column B in column C I have the telephone number. When I type the first name and surname into Sheet 1 A1 i want the correct postcode to...

Hi Everyone, I am trying to find a solution for the below. I have 2 separate spreadsheets that users fill in however, that populate a another workbook. For example the user on form 1 enters their Surname and DOB. On the second Form they then enter their Surname, address and contact number...

Hi, Within a range ( a1..a500)I need to place the first name & surname in to retrospective columns . Below is an example Billy.twoshoes1234@sole.uk I need to remove the . , number & @sole.uk . <tbody> First name surname billy twoshoes </tbody> Then have the 1st name in one col...

Hi Guys Looking to use a formula - probably VLOOKUP - My sheat is a much larger version of the below table that lists employee's first name, surname and then all the dates for a year. I then enter if someone is "A" for "Available", AM for "Available AM only" or PM for "Available PM only"...

Dear All, This is my first post on this forum. I have racked my brains trying to come up with an adequate solution but I haven't been able to find one that works so far. My problem is as follows: I have a database which includes a list of people's names, surnames and I.D. numbers (in that...