middle

Hello! I'm using a donut pie chart in excel for the first time and I was wondering if there was any way to enter the total in the middle of it other than by manually using a text box. For example, if I have 20 on the left side of the pie chart and 30 on the right side of the pie chart, I want...

Hi I have been trying, unsuccessfully, to remove trailing spaces from a set of numbers (all are 10 Characters) whilst keeping any spaces that may exist in the middle. TRIM does not work because some of the numbers have 2 spaces in the middle and the TRIM function removes one of these. I would be...

Hi everyone I am hoping someone can help with this as it is is giving me a headache column A contains cells each of which contains an individual's full legal name This name may include 1, 2,3 or even 4 middle names. I am hoping/looking for a formula/VBA or whatever that would help me reduce...

Hi I use this formula as of now. It works good with first name last name first. It doesn't work good with if a name has a middle initial. Can something be added to this formula to change that the right way also. =IF(B4="","",IF(ISNUMBER(SEARCH(" ",B4))=TRUE,RIGHT(B4,LEN(B4)-FIND(" ",B4))& " " &...

Hi guys, i have a set of data where the whole name is one cell, including the middle name. I want a formula which will organize it by last name, first name middle name. I have one formula which does something similar, but it gives me an error for cells that contain one word, like vacant, or...

I have a document where the name format is Last, First Middle Name/Initial. (Sometimes there is a period at the end of the middle initial, sometimes there is not, see below). I was wondering if it was possible to remove the Middle name/initial using macros. I have found some help but there...

Hi forum gurus, I'm a novice at VBA, having started to learn it on Friday! I have 50 spreadsheets formatted the same as I'm working on now, and I've been writing code to automate the process. There's one step I can't seem to find answers for on the net. Essentially I needed to group data when...

I have a column labeled with patient ID's and I need to add in a few quality control checkpoints. For example: Column A 12134 12355 24345 13523 12312 14321 I would like to add into the data a DOA2 in the center and a DOA3 at the end to look like this: Column A 12134 12355 24345 DOA2 13523...

I have a date range that always covers a span of 3 different months. The net number of days and dates will vary. What formulas can I use to determine the month and year of the middle month? Example: Date range = 3/10/14-5/20/14 Required output = 042014 Thanks for the help!

Hey all, this formula almost does the job: =IF(FIND(" ",A1&" ")-LEN(A1)-1,LEFT(A1,FIND(" ",A1)+FIND(" ",TRIM( MID(A1,FIND(" ",A1)+1,255))&" ")),LEFT(A1,FIND(" ",A1&" ",FIND(" ",A1&" ")+2))) But as you can see in below example, when the last name contains a space (e.g. Martin Marie Anne...

I have a list that are all formatted the same: 12345 City, ST (status) I want to pull out the City,ST from the list I can do a find to find the start position and end position. =find(" ",A1,1) to find start position (i need to use formula here b/c the # length is variable) =find(" (",A1,1) to...

I'm trying to do a vlookup that will match with digits in the middle of a string. For example, I have a reference table that has columns that look like this: ...............A.....................................B sdfd sdf 6.25 mar23/42................23423 wekj sda 3.52...