I want to create a club roster which I can revise & add new members etc.

Hi...I have a sheet with data that looks like this... Col A Col B Col. C Col D joe part1 320 joe part 2 150 betty part 1 350 betty ...

Hello, I have in a cell : 250-PSA-AD46 I would like to replace 250 & AD46 by a space and keep the dashes and PSA in the middle. That was an example of the...

Hello, I'm trying to create a macro that simulates some of the toolbar button (copy, paste,..) namely, I want to emulate the "Back" and "Forward" button...

I have a 2500 line column of street addresses along the lines of (123 E Grand Maple). How can I split this column into two columns, first column only the...

Hello I've been tasked with creating a spreadsheet that records the monthly electricity meter readings where I work. It's a big site with aboout 20 different...

I have a report that was downloaded from an ERP system into an Excel spreadsheet. We manually take the numbers from this spreadsheet and update another in a...

I need to flag ee who are between the ages of 20-29, 30-39, 40-49, 50-59, and 60-69 what would the formual look like just using years eg born between 1976...

Hello, I need to flag milestone yrs of service for our employees. I was able to download the hiredates from my crappy system but the date appears as ...

Hi Can anyone tell me how to calculate the rental of an item Col A would be the date the rental period started Col B rental ended Col C to calculate the...

I have a running schedule with mutlile tasks scheduled for different day # or the same and would like to have the dates auto fill in once I enter the...

Other than copying formulas manually to the next row of empty cells, can a function within the preceding data entry cell do the work upon completion, enter,...

I add records, daily, to a master file. Sometimes a record is a duplicate. At this point, I sort by one column and then scroll down looking for duplicate...

I would like to group colums the way the subtotal function groups rows. With a plus or minus sign to expand or collapse the group. How can I do that?

i want that not more than 4 string should be enter in a cell.......what should be done

I have a project about excel,and I want to design a little game by excel,who can give me some suggestion? Thanks a lot~

I have data on the clipboard which I want to paste into multiple cells in a column that is selected. When I Ctrl+V, it only pastes into the first cell. How...

I've tried searching for " " and replacing it with _ but excel doesn't find any spaces with " ".

how do I use a % range for instance if f13 is 25-75% in a formula