Search results for query: *

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

Is there a way to have a slide's animation only animate once, the first time the slide is viewed. I will be walking through a slide that requires a great deal of animation and revisiting it multiple times after. I would like the animation to appear only the first time I view the slide and no...

Thanks for the help Hasit!

Hasit, Thank you. Very helpful. One additional question, how did you grey out the box chosen after returning to the main screen?

I am developing a training program in PowerPoint and would like to include a jeopardy slide. I was wondering if there is anyway to make the slide interative. I would like to click once on the dollar amount selected by the participant to display the question. I would like to then click again on...

For my application I would like to add validation so that when a user enters a start date, the end date will automatically calculate and generate in the "Week End" field. The week end date will always be 7 days later. The problem arises when the user enters a starting date that is at the end of...