I have series of serial nnumbers in five non-adjacent columns. Ineed to find, and, if possible, highlight them. I am using Excel 2003 at work and 2007 at...

excel 2003 how to find text or symbol in each cell and replace with hard carriage return

I have a drop down box in my spreadsheet that I use for listing the builders that I work with/for. It appears that the max. number of entries is 12. Can I...

I am using Excel 2007, I have a column containing formulas that would return a name if true and a zero if false. I want to search the column for the text...

Hello I would have thought this to be easy but it has be stumped! I have a workbook with 100 sheets (names sheet1 through 100) and I need to retrieve the...

Hope someone can help me with this one which I have been trying to work with no success. Here is what I have in A1 I have a date and in B1 I have a time. Is...

i am trying to create a workbook with 13 worksheets (1 for each of my 28-day pay periods). i have made the first sheet with the dates of my regular...

I can not get the leading zeros to show in my cells I have gone to tools, veiw tab and selected the zero values button and deselected it, and no luck I need to...

PLEASE HELP!? I have a column that is 2000 cells tall each containing numeric four and five digit codes. I need all the four digit codes to receive a '0' in...

Ho campers: An extremely basic question: I have figured out how to concatenate several values from a particular row (e.g. =F2&"."&G2) to get what I need in...

I have several cells that refer to other cells ie: = Sheet1!$b$21 they worked fine until a couple days ago. Now they all have # in them instead of the number...

When I open page 1, it appears on the desktop. When I click on page 2, it appears on the desktop, but page 1 disappears. I want both page 1 and page 2 to...

Halo, im a newbie 2 both VBA and Excel, I was assigned to design a VBA script which can post query and retrieve data from an excel sheet, is it possible to do...

Hello, Is there a way to display the User who printed the document in the Footer? Thanks Ruan

Hi - I have a simple mileage/tracking reimbursement Excel 2007 spreadsheet with 9 columns (A through I). Here's a...

where can i find 98 format in save as? "gls858" wrote in message ... : fortjoly wrote: : How...

Using Excel 97 and am trying to make a simple time card that will calculate employees hours. I want to enter: Time in, Lunch out, Lunch in, Time Out--then have...

Hello, What I am trying to do is lets say I have a bunch of numbers in column F (for illustration purposes I will only show one number) and what I would like...

I need to save file to csv format to transfer to website...2003 always worked fine - 2007 doesn't - help?? -- jo