seperate

Hi I have this excel file with serial numbers of employees. I need to make individual text files of 500 serial numbers. The master list is enclosed. What I am looking for is that I am able to run a VB script that automatically that 1)Opens the worksheet-->DATA( main sheet) of the workbook file...

Greetings all, I hope someone can help me. In Column A, I have Orders (lots). And I want to parse the text into individual items ordered in the columns next to each other. Any suggestions? Thanks in advance! Example: From this Green Man Draft 4.98 Infusion ****tail 7.01 PREMO CAN COCTAIL...

Dear, I have data like this SHORT LONG NOUN MODIFIER ATT N1 ATT V1 ATT N2 ATT V2 ATT N3 ATT V3 CHEMICAL,FAST-DRY SELF VULCANIZING CEMNT CHEMICAL, TYPE:FAST-DRY SELF VULCANIZING CEMENT, PACK SIZE:236.6ML CHEMICAL -- TYPE PACK SIZE CHEMICAL,FLUSH,LOCO,236.6ML CHEMICAL,FLUSH...

I have a sheet that i want to import data to (sheet1 B2) this data is seperated by a comma i want to seperate and create it listed in a single column on (sheet 2 B2, B3, B4 etc) can someone please help with a formula thanks in advance

I have a report that has over 1500 data points. On a separate ws, I want to pull in the top 10 values that are highest to least. how can I do this? Thanks

Hi, I am wanting to have 3 pivot charts that change automatically, but all showing different data. So far i have my pivot showing A = Months B = Percentage C = Sales D = SIH (stock in hand) I have a pivot chart working no problem for the first column which is percentage, i have tried...

The first column contains last name, while the second column contains first name. How can I merge the two columns and seperate the two names with a comma? Thank you

I have 5 workbooks and I need to pull two select, completed sheets out of each of those 5 in order to combine those into a new workbook. From there I am going to use that new workbook to run a print macro I already have. It's just cumbersome to go into each of the 5 workbooks, select the...

Dear all It's been a long time since I sought help from your goodselves and I have forgotten so much that even this seemingly easy task is alluding me. I have scoured the boards to see if I can canabalise code for my purpose but with little success. So here goes - please go easy on me and...

Hi guys, anyone who knows a formula to give a true/false output if cells countain double question marks or two seperate questions marks? This should be the result: <tbody> H?eLlo? True Good?night False Goodmorning?? True ?Goodevening False B??ye True </tbody>

Hi All, I have a large spreadsheet in which the data changes on a monthly basis, each month i need to go through all the rows and find any that are not equal to "0". Unfortunately it is not as simple as applying a filter as there a lot of formatting issues (Which i do not control). Currently...

<colgroup><col></colgroup><tbody> 05August2011 28April2011 23February2010 16June2011 17October2011 10November2012 05September2012 </tbody> I have a list of text on this format. How can i tranform it into date. I tried to seperate them but i'm blocked, i don't know how to convert...

hi, I would like VBA script to select xls or xslx files from chosen location, than convert them to CSV and reopen them as CSV each in seperate sheets ready to work on. Please Help. Thank You :) W.

Hi, I need to group multiple seperate columns. The issue is excel will not let me group seperate columns using the standard group feature. Is anyone aware of any kind of workaround to allow me to emulate this. Normally I would be able to press the + sign to expand and - to retract, I need to...

Afternoon I have a table that holds an open and closed date in 2 seperate columns with a name in another and a column that states open or closed. Is there a way I can create a query that will give me in seperate columns the following Name - Raised Yesteday - Closed yesterday I know how to...

Hi everyone, I have number of cells having complete detail of an employee in one cell (for each) need to split by heading, data is like; Designation: Executive, ID card: 0011, DOJ: 25-May-2016 How can I seperate the data? As I need designation in seperate column, Executive in seperate and so on...

Hi - this seems to be a bit tricky. I've got a sheet with columns - each column, say 3 of them, is a list of items (actually they're summary points from colleagues). I concatenate just using & but clean the text and skip the blanks. I add a CHAR(10) at the end of each point that I concatenate...

Hi, I'd like some advice on improving my timesheet file I use for work. At the moment, I have a seperate excel file for each month with 4 x weekly timesheets as seperate worksheets. I'd like to condense this into one big file, with 52 sheets in, one for each week. I'd like each sheet to be...

Hi everyone, Thank for coming in. I have product informations and would like to seperate into 5 bullet point like below. <tbody> Product Description BP1 BP2 BP3 Solid,durable,waterproof,rustless. A must-have tool for your car. Set you free from the danger by cutting the seat belt. You...

Hello, I'm trying to create a macro in VBA which should convert all cells from B2 and downwards into mutiple columns. I got 8 sheets called D1, D2, ..., D8 - which all need to be affected by this macro. The character to seperate will be a comma. The macro will seperate dates from each other...