len

Hello Excel Experts - I have a dilly of a pickle for you Given the following data: 1. I loaned the sunglasses to Partridge,Keith to use on stage 2. I threw the football to Brady,Marcia but it hit her in the nose 3. Greg bought a guitar and now we call him Bravo,Johnny I'd like to collect...

Hi guys, I'm really quite puzzled on how to extract meaningful information out of a cell. Basically I have a long text string with text, numbers, dates and times in. I need to be able to extract points of interest to me such as when did the issue get reassigned to a particular team (12/2/10...

Hi Everyone :) I have a workbook which I am trying to automate with a macro. This workbook has a formula which basically takes data pasted in from a third party system (standardized data) and converts it to a syntax for a different vendor system. The issue I am having is with the amounts. I...

I've been trying to find a way to use the MID and LEN functions in VB. I have an Excel 2003 spreadsheet that uses multiple dropdown selections placed in one cell. What I would like to do is every time the user accidentally selects something that has already been put in the cell it returns...

If starting on a cell such as D7, how do I reference a PARTIAL folder path listed in cell F7? The path will vary in how many subfolders it has. I simply want to reference the path MINUS the last subfolder. (e.g. \\foldler1\folder2\FolderIDon'tWantToReference, but remember the names of the...

Hello, For two days now I have been trying to figure out how to sum the total of unique names in a column. I found from your site, {=sum(1/countif(array,array))} however that doesn't work. Then I found...