string array

Hi, I have an array in VBA that is filled with string values representing numbers. So, one of them might look like a number, but the type in a locals window would look like Value "128371" Type Variant/String I would like to convert this to an integer before writing out the array to a...

Hi all, I am trying to make a randomizer in Excel to randomize my workouts. I currently have 4 workout lists in Excel: Abs, Arms, Chest, and Legs. The lists are made of strings with no numbers. What I want to do, is to have 3 different buttons, each for a different day (Arm, Chest, and Leg)...

Hi, I have a few hundred cells which all have 4 digits in them seperated by a space. Eg Cell A1 has 4 16 23 43 in it. Cell A2 has 5 78 76 45 in it. What I want to do is have formulas in Columns B,C and D which extracts each number out So cell B1 would have 4 C1 would have 16 and so on. I...

Hello, I am wondering if anyone knows a formula to search for commonly used words in an excel column. I have data where one column is written text filled in by someone and I would like to search all of the columns for the most commonly used words. For example, several cells in column A contain...

Hi All, I have a nicely aligned workbook but there is one small part I am trying to figure out. Our Product unit numbers go from 1-50 however they are all within a string for that product code. I know how to get figures to the left and the right etc but I want to get figures in between certain...

Hi, I have certain mail subjects which are part static part dynamic for e.g. Job ABC_DEF_GHJ:12345 Here the subject preceding the : is fixed, while the one after is dynamic. In a day I will have 100's of such mail subjects, some of them will have common fixed parts, only the dynamic vary...

Working on a new project and thinking about the best way to achieve something. I have a range of cell that each contain a string of names delimited by semi-colons such as "Last, First;Last2, First2;Last3, First3". In the end, I want each name String to be added to an array (I will dedupe the...

I've created dynamic formulas in excel. Unfortunately, it creates the formula as a string. To get around this I created a function (Evalu) that using the Evaluate() function to give me the answer. This currently works fine. However, the problem I now is how to apply this to an array. My...

Hi guys! Well, although I am not very new to excel there are some master tricks that still I don't know. Because of that please tell me step by step like you are explaining to an idiot! I have a "D" column starts from 5th row and goes up to 165th row. Every cell in this column contains both...

Hello, I have one question regarding variable arrays to store string. I'm trying to have the user enter the length of an array, and store a string (file name) into the array for use later. However, I get an error stating "constant expression required". Tried two different ways to set the...