Recent content by LewisReeder

I currently have an "employee type" column/list that contains the choices "FTE" & "Contractor" and an additional column/list that specifies the type of contractor as "long-term" or "project". I now need this all in 1 column/list. Is there a way to convert all this into 1 list without doing it...

Skip - Cant you use the LEFT and RIGHT operators somehow to take the first and last name only. I realize any surnames would be taken instead of the last name but out of the 600 names very few have surnames, so I can reconcile these manually. I also have very few multi-name people. Does this...

Glenn - The middle initial and surnames can be dropped to make things easier. I really only need the first and last name in 2 separate cells. Thanks, Lew

How do I break up a cells that contain people's names? The cells contain FirstName LastName and I want each name in separate cells (for sorting purposes). Some of these cells also have names with a middle initial. I am totally lost so any advice will be helpful. Thank you in advance. Lew

I have a drop down list that I have been using but I need to add a few more choices. I have already selected all the choices for hundreds of cells and I do not want to redo them. Is there a way to add to the list so the additional choices appear without having to redo all the cells? Thanks...

Thanks!

I currently have a column of names(first and last), some are all caps, some are both caps and lower case, some have a middle initial with a period, and some don't have a middle name at all. I'd like them all to have the first letter of each name capital and the rest of the name lower case so...

Thank you very much Blue Dragon, it worked like a charm! Lewis

I used to know how to do this but I havent done it in years. I have a column with peoples names and each cell looks something like this "Smith, John" (no quotations). I want it to look like "John Smith" but I'll take it if I can have the first and last name in separate cells. I just forget...

Thanks guys. It worked. Learn something new everyday, Lew

Skip, Im sorry, I was not clear. I need to hide every row/column that I am not using. Ideally, I do not even want to know that a column exists after the "K" column and the same for rows after 51. Is there a way to hide or remove them completely. I know I have seen it done, just not sure how to...

Hi All, I was wondering how to hide the majority of cells in excel. I currently have a spreadsheet where I only need to see up the "K" column and down to row 51. I would like to hide every other cell except this section of the spreadsheet. I know how to use the hide option, but it requires...

I was wondering if there is a way to group multiple tasks which have the same start and end dates. I want to be able to group them and then link them to the next task that starts at a later date. Also, is there a way to link 2 tasks in which the 2nd task's start date is in the middle of the...

Ok Thanks.

No I cannot. The slide has multiple hyperlinks and I must be able to see which links have been selected (the color changes after the link is clicked).