mrs

Good morning, I have a workbook where I’m using indirect validation to breakdown compliance procedures for processes we’re required to perform. I’m breaking down our source materials from Sections, to Paragraphs, and finally subparagraphs. After I finished with the base data validation, I may...

<tbody> Leader Employee Week Ending Avg Hours Worked AA Mr. Smith 06/30/2019 4.5 AA Mr. Smith 07/07/2019 5.75 AA Mr. Smith 07/14/2019 4.25 AA Mr. Smith 07/21/2019 5.0 BB Dr. Brown 06/30/2019 2.0 BB Dr. Brown 07/07/2019 2.5 CC Mrs. Taylor 06/30/2019...

Hello, The first column contains a string of values as mentioned below . In 2nd column, I need to strip out specific info from Col 1 (as mentioned below). I tried using a formula like this - =LOOKUP(MID(AS2,12,3),{"Lar","X-L"," Sma"},{"Large","X-Large","Small"}) , but its not calculating the...

Hi, I have a list of names below: <colgroup><col></colgroup><tbody> M.P.Tregoning S.C.Williams W.P.Mullins B.M.R.Haslam T.D.Easterby M.J.Attwater Mr M.T.Walford Mrs Dianne Sayer A.W.Carroll R.A.Fahey Mrs A.J.Perrett M.Johnston J.Butler M.W.Easterby R.A.Fahey...

Good day, I am trying to add Mr & Mrs to a formula. I have a long list of names, both single (Mr J Smith) and married couples (Mr AB & Mrs CDE Smith) Currently the formula looks like this: =IFERROR("Dear "&LEFT(A5,FIND(" ",A5,1)-1)&" "&RIGHT(A5,LEN(A5)-FIND("*",SUBSTITUTE(A5,"...

The table I have below is a list of consultant details. <tbody> Consultancy Name Consultant Email Address Phone Number Consultancy 1 Mr Smith smith@cons.com 020 155 6500 Consultancy 1 Ms Wright wright@cons.com 020 155 6501 Consultancy 2 Mr Dunbar dunbar@cons.com 020 155 6502...

So guys, I have a problem...tried using several org chart style fixes...but essentially I have multiple links to the same manager (using the org chart terminology)... So essentially I have the following data Owner, Account, Beneficiaries Mr Smith has account 1 (his own account) Mr Smith is a...

God morning folks, I have the following table: <colgroup><col><col><col><col><col></colgroup><tbody> <colgroup><col><col><col><col><col></colgroup><tbody> Job holder Title Forename Surname Known As Pickford, Mr Leighton Mr Leighton Pickford Baines-Gueye, Mr Richard Mr Richard...

Hello, I am attempting to set up table which will allow me to assess employees who have not submitted a time-sheet. The raw data is as follows <tbody> Employee Number Employee Date Hours 1 Mr A 03/04/2018 8.00 1 Mr A 04/04/2018 8.00 1 Mr A 05/04/2018 8.00 5 Mr B...

Hi I want to be able to comply a master data of all my statistics of my various employees. At present each employee has their own workbook where they input their data on a daily basis and it calculates the monthly total. E.g Mrs. A's workbook worksheet JAN18 <colgroup><col...

I am looking for a VBA to delete All the text after the < and the < too My Sheet has Columns A Thru J and can be anywhere from 2 to 200 rows IE: <tbody> Mrs. Melissa <8268513.cskm> Needs to just be Mrs. Melissa </tbody> So I need to delete everything after the < and the < too. <anytown...

Hi All, I have been tasked to prep a large amount of data for mail merge. However I am faced with this challenge. Can anyone help me, I am thinking an IF statement may work... Here is a snap shot of the basic data (Not real data) A B C D E F...

Hi there I have a column where the names are like "Armstrong C M Mrs" and others "Armstrong A P Mr & Mrs". I need to show these names as "Mrs C M Armstrong" and "Mr & Mrs A P Armstrong" Can anyone help with a formula that can do this? Getting tied up in knots! Thanks!

Hello, I have a large table, in which I need to append to every line of column B (except the first) a comma + space key, and then add the contents of adjacent cell A right next to it. so basically I want to go from this kind of table: <tbody> A B Mr. Smith, John Mrs. Miller, Betty...