seperate

  1. A

    Macros to export from single worksheet based on parameters to multiple txt files

    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...
  2. moshea

    Formula to Parse text for menu items ordered?

    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...
  3. R

    Auto Splitting of Data

    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...
  4. K

    imported comma seperated data

    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
  5. S

    Seperate WS sort highest to lowest

    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
  6. J

    Pivot Charts

    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...
  7. F

    Excel question

    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
  8. U

    Combine selected worksheets in multiple workbooks in a seperate, new workbook

    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...
  9. A

    Entering an IF formula into an adjacent cell with VBA

    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...
  10. R

    Excel formula to look for '??' or 2 seperate '?' characters

    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>
  11. E

    Search next row if conditions are not met

    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...
  12. S

    Convert Text (number and text) into date

    <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...
  13. E

    Convert XLSX to CSV

    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.
  14. N

    Group / hide multiple seperate columns

    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...
  15. G

    Query or Table Issue

    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...
  16. proficient

    Spli data from cell to columns

    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...
  17. R

    *Tricky* - trying to concatenate which will permit bullets when copied out

    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...
  18. M

    Automatically make 52 sheets with correct date

    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...
  19. T

    Seperate product description into 3 bullet points. #Bullet Point, Product Description, Divide, Seperate, Features

    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...
  20. L

    Convert text to columns multiple sheets

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top