Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Split One Cell Data Into Different Cells

macro of the attached sheet.

Actaully i want a macro which are splits one cell data into deiffernt cells or rows.

View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Split Data From 1 Cell Into 2 Cells
I have a list of first names and surnames, the first name and surname are in one cell together but seperated by a commer.

For example in A1 would be Steve, Jones

What I want to do is have this split into two new cells. So in A2 I would have his first name and in A3 his surname. Formula to do this is what I cant get to work.

View Replies!   View Related
Separate/Split Data In One Cell To X Cells
How do I split data in one cell into three cells?






Not all the data is the same, some have more words than others.

View Replies!   View Related
Split Data In Single Cell To Other Cells
What I got going on is a program I use for reporting is shooting out information.. while most of the information it sends to an excel workbook is sectioned by cell, there is a good chunk of information that's dumped into 1 cell. Is there a macro, or something, I can do to separate the information in this single cell, into separate cells? Auto Merged Post Until 24 Hrs Passes;Here is an example of the report. You'll notice a bunch of information in the 'Description' section. What I want to be able to do is run a macro that will seperate the 'Item Number', 'URL', 'Serial Number', 'Model Number', and 'Details' information into seperate cells.

View Replies!   View Related
Split Data In A Cell And Get The Value For The Split Data From A Different Table
Here's my problem. I have a cell where there are many data strings seperated by ",". Each data string has a seperate value of its own like for e.g:
A2: aa,ab,ac

String Value
aa 1
ab 1
ac 3

What I want it accomplish is that, split the A2 cell into the different data string entities seperated by ",", then get the corresponding value of each of the data string entity, and to take the average of all the values of the different data string entities.

View Replies!   View Related
Split Data Into 2 Cells, Text To Columns
i have cells with city and state in them and i'm trying to separate the one column into two columns. the problem is, i'm trying to keep the city name in one column and the state in the other. some of my cells have two word cities like new albany, or upper arlington. the text to columns feature is separating those cells into 3 columns not 2. is there a way to do this?

worthington, oh
upper arlington, oh

text to columns splitting upper arlington into 3 different cells because the only delimiter in the cell is a space. i need to keep upper arlington in one cell and oh in another.

View Replies!   View Related
Split Words In One Cell To Many Cells
I have some data that is imported, it's about 25,000-30,000 characters and 2,300- 3,500 words, it all comes in as one cell, A1, if I do a text to column on it I will loose everything past column IV. Is there anyway a macro can take the data and put each word in a cell by its self starting in A2? The words a have a space between them.

View Replies!   View Related
Way To Split A Single Cell In To Two Cells?
Is there a way to split a single cell in to two cells?

View Replies!   View Related
Split Cell And Insert (not Replace) The New Cells
I need to make sure that splited cells do not replace content of other cells. For example, if A1 has "SDR232, SDR634", this code will split them and put A1 to be "SDR232" and A2 to be "SDR634". BUT what it does is that it actually replaces whatever I have in A2. Is ther anyway to avoid replacing the content of A2?

Sub tst()
Dim X As Variant
X = Split(Range("A1").Value, ",")
Range("A1").Resize(UBound(X) - LBound(X) + 1).Value = Application.Transpose(X)
End Sub

View Replies!   View Related
Search Character In Cell And Split To Two New Cells
I have a spreadsheet that I have to extract from a web based report at work. The problem is that the column that contains the department name also contains the department code in brackets. For example cell A2 will have: (DE) Department A and cell A3 may be (DEPT) Department B.

Now as seen in the example above a code can range from 2 to 4 letters. I wondered if there was a way in code that would search for the ')' character and copy that to the M column and then copy the department name into the N column. So M2 would have 'DE' and column N2 will have 'Department A'.

Also in column G contains the grade name and grade point which are separated by a '/' I would like this to be copied to 2 separate cells say O2 and P2 and so on.

I know this can be done by a formula but I have to do this every month and it would be nice to just click a button to run a macro in my personal.xls file.

The row number various and are usually several thousand. I have attached a sample spreadsheet that only contains 4 rows of data.

View Replies!   View Related
Split Data Within A Cell?
My data within a cell has 3 values separated by commas i.e. abc, def, ghi. I want to separate these values into their own cells. Is there a formula or command that can do this? of course I can go into each cell and cut and paste the values onto another cell, but I have thousands of cells that need to be reformatted.

View Replies!   View Related
Split Data From One Cell...
I'm working on a datasheet that needs some tweaks...

In column A, I have these data
CA 902-20
GA 100-10
UP 200-20
WC 100-20
City #123-89

how can I tidy the data into column B so that they have it will have a standard format of a single letter followed by (no space) 5 digits.
ex: C90220

I am thinking using Left and Right formula, does that sound right?

View Replies!   View Related
Split Cell Data Into Two Columns
I am trying to split data from a cell into two columns. I have tried the LEFT and RIGHT functions but as the data held is not always the same number of characters this does not work for the LEFT function. The only constant thing is that the last character will always be in the second column. An example of data would be:


and I need to be split into 2 columns as follows:

Column 1 Column2
9065-10 A
9065-9 B
9065-11 C

View Replies!   View Related
Split Cell Data In Multiple Rows
I was just not able to figure out how to write a macro for splitting the cell data into multiple rows with the other column values being duplicated. Just elaborating my problem, its like i have a column in which i have multiple values separted by a comma, So i need to divide all these values on basis of a comma and then copy this value to a new row below, along with the previous column values same for this new row. in my file cost center column is to be worked upon. Can this be done by a macro ?

View Replies!   View Related
Extracting Data From One Massive Worksheet To Split To Smaller Sheets Of Data
10/05/0808:30:00 AMValid Card EntryLamDoor 1
10/05/0808:31:00 AMDoor Leave Open Door 1
10/05/0808:32:00 AMDoor Closed Door 1
10/05/0808:41:00 AMValid Card Exit Yap Door 1
10/05/0808:46:00 AMValid Card Exit Lam Door 2
10/05/0809:14:00 AMValid Card EntryLam Door 2
10/05/0810:18:00 AMValid Card Exit Lam Door 2
10/05/0810:19:00 AMValid Card Entry Yap Door 1
10/05/0810:40:00 AMValid Card Exit Yap Door 1
10/05/0810:42:00 AMValid Card EntryLamDoor 2
11/05/0808:30:00 AMValid Card EntryLamDoor 2
11/05/0808:20:00 AMValid Card EntryYapDoor 1
11/05/0810:20:00 AMValid Card Exit Lam Door 1
11/05/0811:40:00 AMValid Card Exit Yap Door 1

the above is the data i need to work with (dates are in dd/mm/yy). i need to find a way (a macro, preferably) to extract the date and time corresponding to one person, and paste it into a new sheet, e.g. at sheet 2 (renamed to "lam") should be

10/05/0808:30:00 AM 11/05/0808:30:00 AM
10/05/0808:46:00 AM 11/05/0810:20:00 AM
10/05/0809:14:00 AM
10/05/0810:18:00 AM
10/05/0810:42:00 AM

View Replies!   View Related
Split An Amount Into Different Cells
Is there an "easy" way (a formula) to split an amount into different cells (periodes) (see the example under)?:

Amount Periode Jan Feb Mar
900 USD 01.01.10-31.03.10 300 300 300

View Replies!   View Related
VBA To Split Size Of Cells
I have created a VBA which organizes data from duplicate accounts into a single row so that it is properly formatted for our email system. The one issue I am having trouble handling is cell overflow. Column B cannot end up with more than 5 pieces of information. Each piece of info is seperated by a comma. If there is overflow, the extra data needs to be moved to the following column.

With the example I have provided, you will see that after running the macro, cell B2 has 18 pieces of information. I need to expand the macro so B2 contains 5 pieces, C2 contains 5 pieces, D2 contains 5 pieces, etc.

View Replies!   View Related
Split Cells With 2 Words Into 2 Cells
My data looks like this:

Mindy Moore
Mace Kook
Cow Moon

These names are in Column A. I want to split the first and last name into Column A and Column B of my spreadsheet. I Usually copy row 1 to a txt file then import with "space" as my delimiter. I basically want an automated method of doing this.

View Replies!   View Related
Split The Characters And Display Other Cells
I want to accept a string, well typically a name say "Manik" from one of the cells in Excel say "B2"; then split it as characters M a n i k and display it in five other cells like say from D2:D6. how can I do it? Also the name may change its not a fixed string.

View Replies!   View Related
Copy Row And Split Values Within Cells
i am trying to copy a row a certain number of times based on the number of values within a cell. (E4:E--) and then split the values contained in that cell into unique rows. i have the following:

3/20/07ARROW INC 2065114 $10,555.24 606 4/6/07
3/18/07NORTON 2017304 $13,206.15 715 4/6/07
3/22/07HARKMAN 2025685$8,127.04 167 226 452 4/6/07
3/19/07AMEREX INC 2019933$14,131.64 186 189 4/6/07
3/23/07G SQUARED 2029062$8,587.68 204 233 4/6/07

what i need is:

3/20/07ARROW INC 2065114 $10,555.24 606 4/6/07
3/18/07NORTON 2017304 $13,206.15 715 4/6/07
3/22/07HARKMAN 2025685$8,127.04 167 4/6/07
3/22/07HARKMAN 2025685$8,127.04 226 4/6/07
3/22/07HARKMAN 2025685$8,127.04 452 4/6/07
3/19/07AMEREX INC 2019933$14,131.64 186 4/6/07
3/19/07AMEREX INC 2019933$14,131.64 189 4/6/07
3/23/07G SQUARED 2029062$8,587.68 204 4/6/07
3/23/07G SQUARED 2029062$8,587.68 233 4/6/07

the number of rows will vary and obviously, the number of rows will increase as the rows are copied X times to correspond to the number of values contained within cell E.

it is not showing correctly, but cell A is date, cell B is company name, cell C is PO number, cell D is price, cell E is Department numbers and cell F is end date.

View Replies!   View Related
Text Split For The Name Only In Cells Where Contains The Word Name
I would like to do a text split for the name only in cells where contains the word "Name". For example: Name A&A Enterprize

Text split function for it is =MID(A1,FIND(" ",A1)+1,255)
so it only recognizes A&A Enterprize.

How would I add an IF, Then function (If the any cell contains the word Name, apply the text split function, for cells don't have the word Name, just leave it blank) if i have to do this for a large data file so i dont have to copy this function for every cell that contains the word Name.

View Replies!   View Related
Split Cells By Bold Text
I have a sheet full of names, addresses and phone numbers in one cell like this

Albert Young 16 teststreer 12C..................7888-6338

The name Albert Young is bold. The thing is I would like to split the cell putting the names in another colomn. Then it would be ideal to split the addresses and phone numbers as well. But I have no idea how to split any of these. I scanned this from a phone book, the dots are different on each row.

View Replies!   View Related
Split Cells Into 2. Space As Delimiter
I recently got this task by my work employer to transfer information from several non-organized Excel-documents into one, complete and organized one.

The thing I have to organize right now is a column with thousands of zipcodes and zones in one single cell, only separated by spaces, like this:

Zipcode Zone
115 54 Gothenburg
443 67 Skane

What I want to do is instead of having to go through 24h of braindead control/paste is to use some easy and fast function or script that could pull out the last piece of string of information in every cell in that column into its own separate cell.

Although I am using Open Office Calc/Gnumeric on Ubuntu Dapper, if a script is necessary and only work with Excel on Windows/Mac, that is no big problem for me to solve. So please, any suggestion is welcome.

I will attatch two examples for you to look at, to get the whole picture.

View Replies!   View Related
Keywords As Delimiter To Split Cells
I've got a column of data containing addresses. What I want to do is split the column after certain keywords such as "street", "road", "close" etc and move any words that come after these in the cell into the next cell to the right.

For example, in one cell I might have "54 Burberry Road Finsbury London"... what I want to do is have part of the text remain in the original cell i.e. "54 Burberry Road" and the rest, "Finsbury London", moved to the cell on the right.

Not all cells in the column will match this format so if it doesn't find a keyword, nothing will occur and it will move to the next cell down etc. until it reaches the end of the column.

There are no delimiters (apart from the spaces) between the words.

I haven't figured out all of the keywords that I will need to search for yet but I should be able to extrapolate from something fairly generic.

View Replies!   View Related
Split Cells Based On Letters Vs. Numbers
I have a column in one of my spreadsheets that I would like to split. There's currently not anything that can be used as a delimiter, nor can I use fixed width. the cells in question start with numbers and end with letters.

View Replies!   View Related
Select Random Row, Split Cells To Different Worksheets
I am trying to write a macro to:

1. Randomly selects 50 rows from 834 on "worksheet 1". There are only two cells per row.

2. Then, it clears "worksheet 2" and "worksheet 3".

3. From each selected row in "Worksheet 1", it splits the two cells and copies the results into two different worksheets, one column per sheet.

4. The rows in the two new worksheets should be congruent (i.e. same selected order from worksheet 1). Keeping the order the same is important.

This is what I have so far:

Sub Macro1()
Dim rng As Range
Dim iRow As Long
With Rows("1:834")
iRow = Fix(Rnd() * 834 + 1)
If rng Is Nothing Then
Set rng = .Rows(iRow)
Set rng = Union(rng, .Rows(iRow))
End If
Loop Until rng.Areas.Count >= 50
End With


Selection.Copy Sheets("Sheet2").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0)

End Sub

View Replies!   View Related
Split Address Blocks Across Multiple Cells
I have cells of block addresses that are delimited (tab I believe - there's a
small square that appears).

I need to split the addresses out into separate columns for each line of address. I tried using the Text to Columns wizard as suggested by Excel Help, but ended up with only the first line of address being posted in the cell to the right (the rest of the address was nowhere to be seen).

I'm sure I've done this before but can't for the life of me remember how I did it.

View Replies!   View Related
Split Multi-Lined Cells Into Columns
So I have a worksheet filled with a lot of text in individual cells in one column. What I would like to do is split up the text into different columns in one row so that I can use it easier. The data would be seperated by blank lines within the cell (basically when you hit alt+Enter in the cell). Sample data of a cell is below...

Cell A1:
Directions: Baking an Apple Pie

First you must .... etc

Total time required: 30 minutes

What I would love to be able to do is split up the above sample cell into three different columns, in the same row. So the above cell would become...

Cell: A1 Cell: B1 Cell: C1
Directions: Baking an Apple Pie | First you must .... etc | Total time required: 30 minutes

And then so on and so forth for the rest of the data in that column. I realize that VBA code will be needed for the above... I searched the forum for something that would address this particular issue but have had no luck.

View Replies!   View Related
Split 1st & Last Names & Split Addresses After 1st Comma
I'm using Excel 2000 and I have a spreadsheet with 4 columns (A-D) and many (500+) rows.

Part 1:
Colums A & B both contain identical data - a first name and a last name in the format "John Doe".

I want the second word ("Doe") removed from all cells in Column A so that only the first name remains, and I want the first word ("John") to be removed from every cell in Column B so that only the last name remains.

So, where A1 & B1 both started with the data "John Doe" now A1 contains only "John" and B1 contains only "Doe".

Part 2:
Column C contains addresses in the format:
"#5 - 123 Fake Street, Some City, CA 90210"

There is ALWAYS a comma and a space after the street address, then the name of the city or town followed by more data which may include one or more commas.

I would like everything BEFORE the first comma to remain in column C, and everything AFTER the first comma & space to be moved into Column D of the same row. The first comma and space are not needed again.

So, where C1 started with "#5 - 123 Fake Street, Some City, CA 90210", it now only contains "#5 - 123 Fake Street" and D1 now contains "Some City, CA 90210".

View Replies!   View Related
Macro To Split Cells Into Inserted New Row And Copy The Rest Of The Row Into It.
I need a macro that can search text cells in column L for a space delimiter, then if the space is present, to split that cell into a row inserted below it, then copy the information in the rest of the row down. I'm not really up on my VBA.

View Replies!   View Related
Split Data Into Separate Spreadsheets
every month I import (from SAP) Local Authority staffing data for 200 schools into an Excel template. After a bit of tweaking I end up with a single spreadsheet showing formatted and adjusted data for all schools, with relevant headings separated by page breaks.

This is fine if for distributing a hard copy to schools, but I want to email it. I've seen macros that would allow data to be split onto separate tabs, but is there a way to break it down into 200 separate spreadsheets? I confess to not knowing any VBA, so be gentle with me

View Replies!   View Related
Split Data In One Column Into Two Columns
For each cell in column A, I am trying to split the data between two new cells. The data in each cell is separated by a “|”. All information to the left of “|” should go in column B. All information to the right of “|” should go in column C.

Column A
Aa3 |AAA
A3 |AA-
A2 |A
A3 |BBB+
Aa3 |AA
Aa2 |AA+

Desired Results
Column B………….Column C

View Replies!   View Related
Split Data Into Adjacent Columns
I am looking for two formulas (col. B+C) in order to split every second value from Col. A into two adjacent columns. Empty cells, in col. A, should be ignored. The requested result is shown in green and red.

View Replies!   View Related
Split Range Data For CSV File
I've got an Excel document that is generated from a third party programme (See ExcelDoc attached)

I'm trying to manipulate it so that a macro creates a CSV file like the one attached (see THK.csv)

I need to have the following columns in the CSV file populated using the Excel spreadsheet

Column A: Will need to have the NUMBER that is in cell B2 of the Excel file in this case the number is 0714 (need to keep the preceeding 0 too)

Column B: Will need the phone number
Column C: Will need the fax number
Column D: Will need to have the email address
Column E: Will need to have the date only
Column F: Will need to have the Order Number
Column G: Will need to have the Customer name
Column H: Will need to have the Customer telephone number
Column I: Will need to have the Customer alternative telephone number
**Column J: Will need to have the 1st line of the address (after First Address in xls doc)

I've managed to get a macro that will take the information and transpose it into a new document and rename it as an CSV file but I am having a lot of problems trying to get the macro to create the CSV file in the format that I need (see following macro)

Sub CreateCSV1()

Dim wbMyBook As Workbook, iAddPos As Integer

Application. ScreenUpdating = False
Range("A1").PasteSpecial (xlPasteValues), Transpose:=True
Range("A1") = Left(Range("A1"), InStr(Range("A1"), " ="))
iAddPos = InStr(Range("J1"), "TEGKON:")

I've attached the xls document (the one that is generated and the CSV file which is the format I'm trying to achieve.)

**This cell is generated and will have commas at the end of each line of the address and will be terminated by a period (at line 4 of the address. Sometimes there will be 4 lines to an address but sometimes there may only be 2 or three. In the case where there is no information I need to have a blank ( null) value in the cell

View Replies!   View Related
Compare Adjacent Cells, And Split Alpha Numeric String
I have another problem with this damn address file. Column H and I have data in them that is often mixed. As shown below, I have used A and B below, but its normaly in Column H and I. I would be greatul if some could write a macro to split the data into the two columns.

Rows 2-8 is what Im presented with. I would like them to look like 11-17

Note that the number in row 8 does not match, so is left for manual intervention....

View Replies!   View Related
Summarise Data After Applying Allocation Split
The task involves summarising about 10,000 lines of data into months by Plant by Process. I can achieve it by stepping through a couple of schedules but I'm sure it can be done using one formula (but I can't find it!).

View Replies!   View Related
Split String Of Data Into Columns And Rows
I am looking for a way to split a large string (400 numeric value's, split by comma's) into a 20x20 field.

If possible, the field should be 600x400 pixels (30x20 squares), but this is just extra
Is there a way to do this in Excel (or any other program)?

View Replies!   View Related
Spliting A Column So 1 Data String Can Split In 2
I am having trouble figuring out how to split the data in a column.

For Example on the attached .xls - the first few records under the SIC column are:


& how i want them to look in seperate columns:

73 790200
59 470104
70 110100
58 1223

I need the first two digits in their own column and the rest of the number in it's own column. I have over 6,000 records, so doing it manually is not a place I want to go!

View Replies!   View Related
Split Numbers And Split Words
How do I split numbers!

I have two problems/challenges!

Part I...
I got the answer 1987, and now I want Excel to take the numbers out and display...
1 in one box then i set + in the next, then 9 in the 3ed. box, next box +, then 8, then +, then 7 in the last so that i can have Excel make a SUM of it all to 25.

How do I split 1987 and put the numbers in different boxes?

Part II...
I want to make A=1 B=2... all the way up to 9, then start over again with J=1 K=2... up to 9 again and then over again.

So that if I write my name it comes out as a value of 14 (Odd = O=6 D=4 D=4 =14)

(AJSØ=1 BKTÅ=2 CLU=3 DMV=4 ENW=5 FOX=6 GPY=7 HQZ=8 IRÆ=9, It's the Norwegian alphabet, that's why there are some extra letters)

So how do I set up my Excel so that is ANY name is typed in I can get it out into a number from the values assign?

View Replies!   View Related
Split Data In Multiple CSV Files Based On Condition
I have a few CSV files that sits in a folder ie C:/Data and I want to split the data in those files into different sheets. Each of those files contains rows of data with an account number. For example, I have 3 files that contains transactions and they have accounts "Orange", Apple, pear, I want to put all transations with account apple together and all Orange transaction together etc etc.

View Replies!   View Related
Split Data Into Multiple Worksheets Based On Column
I have a huge Excel spreadsheet going into the 10 000 mark.

What I want to do is split the spreadsheet into multiple worksheets based on the Company column.

I've attached a small sample.

View Replies!   View Related
Split Cell Into 2
I have a column with info like

name - name

as in (column a): frank - john

I want to split that into 2 cells(columns) and drop the -, what is the best way ?

so now column b would have frank and c would have john.

View Replies!   View Related
Split Cell Format
I am looking for a method of combining 2 pieces of data into 1 cell

ie 2 Cells merged? and/or formatted? as one split cell as per the mock-up in the attached word document.

120 Enquiries, Closing Ratio of 40%

to look something like the attached

View Replies!   View Related
Split A Cell In Half
Is there any way I can split a cell in half, so I can put numbers in the left part of the cell, and the right part?

If so, I would I refer to those numbers in my macro?

View Replies!   View Related
Split Cell Contents
The columns A & B need to be split as shown in the table (3 columns as shown in D,E & F)
In column A the hrs needs removing, but there is also some spaces at the front of this text which needs removing.
Column B needs splitting as shown in the table.

******** ******************** ************************************************************************>Microsoft Excel - MAPPED SCHEDULE.xls___Running: 11.0 : OS = (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutA1=ABCDEF1 4.3 hrs1-08-739677-00 U1 DC STATOR COOLANT PMP 4.301-08-739677-00U1 DC STATOR COOLANT PMP2 1.1 hrs1-08-739543-00 SW/BD ALARMS FAILED 1.101-08-739543-00SW/BD ALARMS FAILED3 1.1 hrs1-08-739544-00 ALARMS FAILED ON TEST 1.101-08-739544-00ALARMS FAILED ON TESTSheet2 [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name boxPLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

View Replies!   View Related
Split String In A Cell
I need to split a string in all cells in one column (delimiter = ""). What I basically want is to get just the first word in the cell.

View Replies!   View Related
Split Names From 1 Cell To Many
Is it possible to copy specific names based on cell content?

For example:
If I have a cell containing text and the names Bob, Mary, Bill,

I would like have a macro read the contents of the cell, find each name "Bob", "Mary", "Bill", then write their names in the first available cells to the right.

ie: If Cell A1 contains Bob, Mary, Bill
write the names in the next available cells ( in any order)

Cell B1 = Bob
Cell C1 = Mary
Call D1 = Bill

It would be great if this can be done within a range..

If anywhere A1:A100 contains the names Bob, Mary, Bill,
to write the names Bob, Mary, Bill ,in their next available cells.

Also, I have a few dozen names that i'll be incorporating in my worksheet which I'm hoping to expand on.

View Replies!   View Related
Split Contents Of A Cell
i'm trying to do is split the contents of the cells in column A in to 2 seperate cells. The contents of the cells in column A are like this: alpha.bravo.charlie. I want to delete alpha and have bravo as the new contents of column A and charlie as the contents of column C.

View Replies!   View Related
Split Cell With 2 Different Delimiters
I'm trying to split a cell with 2 different delimiters.
As example

A1 10'48"
B1 10
C1 48

I have about 10.000 entries like those. And i think a macro should be the most suitable for it.

But I'm not experienced enough to make it work.

View Replies!   View Related
Split Data From A Large Spreadsheet By Selected Column Into Multiple Workbooks
I have a large spreadsheet which I need to split into individual workbooks by reference to a particular column.

Rather then doing this manually and splitting the data out one at a time - I would like a macro to do this for me.

I am a novice excel user.

View Replies!   View Related
Split Cell By Delimiter, Move To New Row
I'm prepping this file to be pushed through mail merge. The sheet has 25,213 rows.

Column I contains a long string of character (for the purposes of my project the field is called Subjects) and $ used as delimiters (approx 70 or as few as 1). This column needs to be split apart by $ and the separate Subjects that result from splitting apart by $ needs to be placed on a separate line. Once each Subject is on a separate line, all of the Subjects need to be lined up in Column I, one under another (the obvious result at this point is GREATLY increasing the number of rows in the sheet). Next, all of the data that is contained in each Subject's originating row will be copied to each of newly created rows (without copying over the Subject contained in column I).

After writing this all out, I realize (once again).

View Replies!   View Related
Copyright © 2005-08, All rights reserved