jose

Hello. Seeking a formula to add up all the hours worked by each volunteer. Thank you. <colgroup><col><col></colgroup><tbody> Who Hours tracking Alejandro Grand 2 Alicia Gibbs 2 Alicia Gibbs 4 Amaury Sainvil 2 Amin Farschchi 2 Amin Farschchi 2 Anthony Moore 2 Anthony Moore 2...

I've tried to figure out how to find specific text in a string of text and darned if I can. In the example below I am trying to find the city name San Jose in a long string of text and then have San Jose stated in another column. However, when I use this code below, I get San Jose populated in...

Hello Excelperts, I find myself in a bit of a conundrum and looking for your help and expertise to learn how to pull a substring from a cell of variable length string. From the transcript column A1, I have variable length transcript string, what I am looking to extract is the name of the...

Hello there! A couple of months not touching Excel seem to have dried my brain out and I'm out of ideas. I have this type of schedule table for around 60 ppl that extends throughout the year. <tbody> 01/01/18 02/01/18 03/01/18 04/01/18 John A B OFF OFF Paul A1 B1 A B George B A OFF...

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))& " " &...