seperate

I am trying to separate out the first four or five numbers in a cell that are followed by two or three letters and then followed by two or three more numbers. The problem I am running into is there are no spaces separating any characters. The cells will look like the following. 13244vww98 or...

Hi all, I have a sheet of quite basic data, and would like to generate a table from it which reflects the number of times each sequence of data occurs. I had it figured out I suppose, then got caught out by the stumbling block - this report is run daily, the date will change each day and I...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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