I think this works assuming you dont need to go back to the twenties in your list, try it In A1 02 12 03 23:43 is 37957.98865 so =LEFT(A1,5) is 37957 and

I wish to save a tab delimited worksheet with items starting in specific columns. For example, company name starts in col 7, address startes in col 27 and so...

Hi! I having 1 problem that Excel formula is calculating wrong total number on some of cells. For...

Downloaded a ws and can't edit it due to protection, which requires a password to remove the protection. Sender insists it's not protected. Forwarded the ws...

Does anyone know if it is possible to use a formular that would return a selected range (from a different worksheet), based on the content of a given...

Where can I find a listing of characters using alt keys

I have say an item i need moving from say c340 and i need it to be moved to d339 and then a nother item moved from c341 and i need it moved to e339 and this...

Hi Nick, This is hilarious, needs sound, Alan. http://www.youtube.com/watch?v=s8GNgnm4jvo

Hi All, I need to work out how to concatenate an array of four strings skin to the following (which does not...

Hi Could do with some help please. Trying to set up a work rota of names using a MS Excel spreadsheet - no problem there except, I would like to have a 'Drop...

If you want to increase all of the cells in your range by two for instance, then in a empty cell enter two (2), right click and copy it. Then highlight your...

Lets say Cell A1 contains the following text string: "Hello Yellow Mellow" How do I count the total number of L's in that cell Find and Search functions...

=SUMPRODUCT((A1:A0="AZ")*(B1:B10)) will do the sums, not quite sure what you mean about the text values, Regards, Alan, "profusek "...

I am send data to an Excel Spreadsheet, which includes some numeric data and some text data. I want to have the text in all columns in the centre of the...

I have a six column data range, with column names, and around 500 row entries that records sales data for accounts. This data is produced weekly, always in the...

Hi All, Is there any way to 'evaluate' a dotted number (similar to an IPv4 address but not just those) using standard worksheet formulae (ie no UDFs, VBA, or...

I have an Excel list of phone numbers that I need to add parenthesis around the area code. Anyone know how to do this? The list is about 3,000 numbers.

I would like to be able to enter data on sheet 1, and also into another cell on a different sheet with a different layout at the same time. Is this possible? I...

My worksheet has Date.Ordered in COL-A and Date.Filled in COL-F. I can find the oldest date in Date.Ordered by using the SMALL function. However, when I...

I have a table of data that has a variable number of columns i.e. week 1 in column A, week 2 in column B and so on. More data is added as another week...