1. H

    Merging data in cells and seperating by a comma in 1 cell

    Hi there I have been working and trying everything I can think of and using other examples to try and get this project finished but just can't seem to do it I have worksheet with up to as many as 200 or 300 phone numbers in row 1. Each cell holds its own phone number. Each time I run this...
  2. K

    Finding Common Items

    Hi, I'm having some trouble with comparing two sheets found in two different workbooks and highlighting any common items between them, I'm hoping there is an easy way to do this? If the two sheets were in the same workbook I could probably work it out but because they're different files I'm...
  3. J

    Seperate data in a cell

    I Need to separate the item # / from the description in column A? I have about 2000 rows. Once the number is removed I need to place that number in Column B next to the description. Ex. A <tbody> 1 4986238 / SHOE ORTHOWEDGE FOREFOOT OPEN TOE...
  4. M

    VBA - Arrange Data in chronological order referencing 3 seperate columns

    Hi, I am trying to create a macro that will arange my data in chronological order from oldest to newest. I have 3 seperate columns (G, I & K) which contain dates, although some of the cells may be blank or contain dates in each column. Is it possible to find the earliest date in each row...
  5. M

    HELP please! IF function for multible different numbers

    Hi! I want to try to use the IF function to make a car option with both positive and negative attributes out of 12 ratings a participant gives about these 12 attributes. For the car i want the following ratings to be positive: 1,3,4,6,7,8,10,12, whereas the others inbetween are supposed to be...
  6. M

    Seperating a Workbook

    Created a workbook with 6 sheets. Due to access requirements to the document, I need now to split it up into 3 different workbooks. Each workbook will be housed in its own older, then sitting in a master folder (the folder structure permissions were easier to control in SharePoint). How do I...
  7. G

    Seperating Text String

    Hello Everyone, I have a single text string of names from Outlook seperated by a semi-colon that are in one cell in excel. I am looking for a formula to seperate those 30 plus names into seperate cells. Does anyone have a formula that will do that? eg: John Smith; Jane Doe; John Doe; Jane...
  8. N

    Need to separate column data into headers

    I have a spreadsheet that has a single column with multiple values, an identifier and a percentage. What I need to do is separate that data so that the identifier is copied and made into a column header and the percentage related to that identifier is in that column. HERE is a sample of the data...
  9. S

    How to add a Custom menu TAB for Seperate work book

    Dear all, Can any one help me on this, :( I need to add a own menu tab and its option or button for seperate work book which should not be visible in other workbook. FYI : I am using excel 2010 and the excel file is macro enabled file(.xlsm) Please help me on this.Its urgent.:confused...
  10. E

    Send seperate parts of a table to individual email addresses

    Hiya Guys, Is there a way in EXL 2007 to automatically send an email out to a number of people, seperating the rows of the table that relates to that email address? To clarify: We extract a table of results from a system that includes individuals email addresses, and send a standard email...
  11. L

    Copy & Paste Conditional Formatting In Seperate Columns

    Hi, I'm trying to figure out how to copy & paste the following conditional formatting down the column. The conditional formatting I'm using is in cell A1, D1, G1, J1, M1 (so I have to Ctrl click each cell manually & I then choose to "format the values that rank in the:" "bottom 1" & format...
  12. R

    Column to a row and repeat!

    Hi, I hope someone can help me with this annoying problem. I have some information in a column like this: <TABLE style="WIDTH: 63pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=84><COLGROUP><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 3072"...
  13. H

    How can I add a space between every digit in a cell?

    Basically I have one cell, call it A1, with over 1200 digits in it. All I need to do is put a space between each one so I can eventually use text to columns via delimited to get each individual number in its own cell. I consider myself a master of excel and this simple thing stumped me and made...
  14. A

    Separate an address string into parts using VBA

    Hello, I have an address string that I need to split up into three cells using vba with the mid, right, and left functions. The problem that I'm having is that I can't seem to formulate the functions in which they can handle different forms of the address. For example, New York, NY 23658...
  15. B

    Numbers and Text in the same cell - Need to Seperate

    This is a problem I have seen too many times, I have a spreadsheet with a list of SKUs, of varying character length, formatted as a mix of numbers and text. Many of the SKUs in this column are simple #s (eg 555002), but others have a letter or two added on to the end to indicate a slight...
  16. G

    Seperating Numbers

    I'm new to excel and finding it hard to do the following, I wish to seperate a series of numbers into their own coloumns. The numbers are in the format 01:02:03.04 , Note numbers are seperated by colons and full stops. I gather I may need to convert them to text first but all my attempts convert...
  17. I

    Can you automatically save each sheet as a seperate file?

    I have around 400 spreadsheets each containg half a dozen sheets. I need to save each sheet as a seperate file and then I will use SAS to pull data from each of them. I can't see a way to do this in Excel other than manually. Can it be done with a macro? Any guidance much apppreciated.
  18. M

    Isolating Specific Data

    I have data that I'm copying from a PDF and pasting in an excel sheet. The data that I need is mostly in groups of three rows, but sometimes there will be two extra rows under each data group. The two extra lines are extremely similar to two of the lines of data I need, so I can't think of a way...

Some videos you may like

This Week's Hot Topics