separated

Good morning all, I wish you could help me on this matter. I am looking for getting all selected row number in different variables through VBA. The selected rows may be separated from each other by using #control button# For example If i select 1:1 - 5:5 -9:9 I want to get the result like...

Hello All, I have some text in four cells separated within the cells by Week. How can I get each Week + text separated into its own cell in a column format? A1:A4 is what I'm starting with with the results in column C. In essence, there will be 13 weeks per cell in column A to make a year...

Hi!, My variable has the string in the following format key = ABCD8E-FG6HI-7JKLMN (alpha numeric) separated with dash Note that the length of the key is not fixed. Required output partA = ABCD8E PartB = FG6HI PartC =7JKLMN Thank you!

Hello I am trying to write a vba-code which will save my Excel file as a semicolon separated values file. Unfortunately my results so far are halting. Both pieces of code below create a semicolon separated values file, but only if I save them manually. If I just close the worksheet the file is...

I know there is a way to search for multiple instances of a value and return all of those instances separated by commas. I am wondering if there is a way to use VLOOKUP (or any other formula/VBA) to search for something like "English1,English2,English3" and return "Spanish1,Spanish2,Spanish3"...

I want to save a excel table to a text file and each cell must be separated by│in the text file?

Ok, you guys have been a big help, so here's a tough one. At least for me! Lol. I want to open a file dialog box in excel when clicking on say a button in cell A1, choose a series of files and have then automatically renamed with info from say cells, A2, A3, A4 and then resaved, with the new...

Hi guys, I can't find a code that will help me with this anywhere. I have a cell in Excel that may contain multiple names separated by a comma - I want to have these names converted to Initials but still separated by commas eg: Cell A2 contains "John Smith, Betty White, Michael Jackson". I...

Dear Excel brains of the world, I have a data validation conundrum; spent an hour looking for a solution to no avail :( I have the following list of values: AR, ARNC, ARNF, ARSAP, B, C, E, ER, ES, N, T, V To prevent user error, I need to be able to add a Data Validation rule into the...

In one column I have a single date and in another column I have multiple dates separated by a comma. I am trying to figure out a formula that will return the max date in the second column only if it is before the date in the first. So the answer to the date I would like it to find in the below...

I have a text string in say, A6 separated by semicolon, comprising of 8 words which looks something like this dog;cat;mouse;tiger;squirrel,moose,panther,lion I would like to extract the 4th, 5th and 8th word i.e. tiger, squirrel and lion in D6, E6 and F6 respectively. After extraction, D6...

Is there a way using either a macro or find->replace to remove all single words from a list of words separated by commas? For example, if I have a cell with the words “john smith,john myers,mike,john excel” I would like to remove the single word “mike” since it has no associated last name. I...

I am trying to bring a set of values (either a set of 3 or 4 values) look up in a row of data with unique values in each cell, and if any or all of the values match, extract them to target single cell comma separated if necessary. Any help to achieve this would be appreciated. Thanks. Here the...

I'm trying for a few days to get this done right, so I thought I should ask for help in this forum. So, I have 2 tables like this: Table1 with 2 columns: OrderID(alphanumerical formatted as text) and Price($) Table2 that has a column ServiceID (number), and Orders (same as OrderID, but...