Separating Cells In A Worksheet
Jan 2, 2009
Set up a worksheet so that it has 2 separate sections in the same worksheet ????? I am wanting to have 2 different sets of information in the same worksheet - and need the columns to be different sizes based on the information i want to put in. Is there any way to have this done - as I know that if you change the column width it does all columns - and i only want to do select columns. For example for section 1 - i would like to have the column widths as follows:
A1 = 20
B1 = 40
C1 = 10
D1 = 20
E1 = 40
A3 = 20
B3 = 40
C3 = 10
D3 = 20
E3 = 40
This is where i want to put details such as names, dates and results.
Then for section 2 - i would like to have the column width as follows:
A6 = 10
B6 = 45
C6 = 15
D6 = 30
This is where i want to have a set of questions to answer.
View 4 Replies
ADVERTISEMENT
Aug 6, 2007
I have rows of cells with the following information..
Row 1, Column 1: Address City/State
Example: 111 Old Creek Road Stanton, VA 25523
Is there any way to separate the Address and the City/State? I would much rather the spreadsheet be in the following format.
Row 1, Column 1: Address
Row 1, Column 2: City/State
or ..
Row 1, Column 1: 111 Old Creek Road
Row 1, Column 2: Stanton, VA 25523
I'm just wondering if there's a fast way to do this, or if I have to go in and do it manually - the reason i'm looking for a faster way to do this is because I have approximately 3000 rows to do it to. :shrugs:
View 9 Replies
View Related
Jun 12, 2014
All words are in Cell A, separated by the ";" symbol. I want separate into different Cells. Example... Lead_ID in Cell A1, Application Data in A2, Date Purchased in Cell A3 and so on.
lead_id;application_date;date_purchased;first_name;last_name;email;day_phone;work_phone;
best_time;city;state;zip;addr;cred_rating;cred_score;yearly_income;prop_state;prop_type;purpose;
loan_amount;prop_value;ltv;mtg_bal1;mtg_bal2;services;credit_repair;foreclosure;debt_management;comments
View 5 Replies
View Related
Oct 8, 2008
I am working on this project for work that is pretty large (about 13500 rows) that is filled with items that I currently have sorted alphebetically. What I need to do is if there is a group of cells that have the same code, I need to insert a row at the very end of that group and autosum the quantity. It is becoming very time consuming doing it all by hand so I am trying to find out: is there a function that will automatically insert a row after each group of codes?
View 2 Replies
View Related
Aug 28, 2007
Whenever I get information from finance.yahoo.com or from my job and put it into excel all the information seems to go in one cell and numerous rows. (I think its b/c I am putting information that isnt' meant to be in excel and forcing it to open up there.)
For Example in cell A1 I will have
"AIG , AMER INTL GROUP I , 66.08 , 1:16pm , 169.455B , 16.736 , 2.01 , 9.47 , 0.78"
Cell A2 I will have
GOOG , GOOGLE , 508.9 , 1:21pm , 158.845B , 22.361 , 17.511 , 26.29 , 1
What I want to see is cell A1 as AIG and cell B1 as 66.08 and cell A2 - GOOG and cell B2 508.9. I don't even want the rest of the stuff.
Is there any way or formula I can use to just pull the information out of cell and have it separated for me?
View 11 Replies
View Related
Mar 3, 2013
I attached sample file with data I received (more than 50k rows in each file) is contained in 86 files with varying population lengths in each file that needs to be broken down as shown in the attached file.
View 5 Replies
View Related
Aug 18, 2009
I need to take data from a cell that has a space "cherry banana", and make it into two cells "cherry" and "banana". I want to duplicate my line on which the data resides, if possible.
What I have is a sheet like this:
View 5 Replies
View Related
Jan 9, 2009
I have a spreadsheet which needs formatting I was wondering if anyone would be able to help with creating a macro to do so. The problem with raw report is that in cell A47 there are five columns worth of data in that one cell, then in B48 there are another two, in b49 and b50 one respectively. I manually format it by first joining the separate cells using
View 11 Replies
View Related
Jan 29, 2007
how to combine the content of 2 cells into one cell and have the information separated by a comma.
For example:
CELL 1:
Software 1
CELL 2:
Spreadsheet Software
The desired results is:
CELL 3:
Software 1, Spreadsheet Software
View 3 Replies
View Related
Feb 22, 2010
I have a form where users can input a Date by utilizing 3 drop down combo boxes. Once they've made their selection that Date gets written to a cell on the worksheet. If for some reason they need to change that Date, they would reopen the form and select a new Day month or year.
I would like the three comboboxes to show the D/M/Y previous written to the worksheet. But I would have to split up the date that has since been concatenated.
View 8 Replies
View Related
Jun 28, 2013
I have a spread sheet with thousands of addresses in them.
It does not hold the state however.
I need to separate each part of the address into it's own cell on the same sheet.
Keeping the first part ONLY of the address in the original place the address was in.
However not having the city, or zip in that cell.
For example:
E2 holds the address: 19505 45th Ave. W. Suite A, Lynnwood 90821
(There is always a comma before the city. However sometimes there is another comma before Suite...)
I want the end result to be:
E2: 19505 45th Ave. W. Suite A
I2: Lynnwood
K2: 90821
Then I would like it to loop through all the address's in the "E" Column until it has edited all the address's. It is sad to say but I have been working on this for over 48 hours... Can't believe no one online hasn't come up with a clear answer on how to do this. At this point I am looking for the code to make this happen in Excel VBA.
View 9 Replies
View Related
Sep 16, 2008
[data] ....
I'm having a problem seperating the prices in Colomn H into three seperate cells C,E & G
The first figure in c is easy enough if a little long (any possible tidier solutions?)
The second Im not happy with it is clumsy using the fixed lenght figure "5"
The last I cant figure out probably because Ive done the second incorrectly!
Finally I can not see why figures apear in away team.
View 9 Replies
View Related
Feb 7, 2014
I need to reference the projected and actual expenses from the total on worksheet 'expenses' So i did so, however, if I change the drop down on the expenses worksheet to only display housing data, then the projected and actual expenses on my budget worksheet changes as well to the new data portrayed on the expenses worksheet.
I need to reference the cell, without it changing when I change the category display, but I need the cell to change accordingly if I enter new data in the overall tablet on the expenses worksheet.
Or do I need to create a seperate worksheet that has the data in and reference my cells on my budget worksheet to that new worksheet?
View 1 Replies
View Related
Sep 24, 2012
I've been tackling this data capture/paste issue for a week or so. I found the string below which does provide a good foundation for my challenge. But, my basic level of understanding macros limits my modifications to meet my needs.
[URL] ......
I have 20 worksheets in my master file corresponding to Excel files individual associates will update weekly. After the associates have updated their individual files for the week, I want to capture the data entered and paste values into a master file containing a worksheet for each associate (sharing the same name as the individual associate file). All of these files are housed on team SharePoint sites.
I need a macro to perform several steps after clicking a "Run Update" macro button in the master file:
Open individual associate fileIn master file, search for each Initiative listed in column B (starting cell B3) in the individual associate file (in column B starting at cell B11)If Initiative is found in individual associate file, copy adjacent data in columns D:J for the respective rowIn master file, paste values to the corresponding Initiative row for the corresponding week's worth of dataIf Initiative is not found in the individual associate file, move to the next Initiative listed in the master fileRepeat these steps for each individual associate file
Linking would be the easiest way to accomplish this if I wanted to have a multitude of weekly individual files for the associates. However, I'd rather each associate have one file for them to update (basically overwriting their previous week's entries).
I need to ensure the paste values corresponds to the appropriate day of the week. In simpler terms, if the date in the individual associate file in cell D9 reads Oct 1, 2012, the data captured from that row needs to be pasted to the corresponding row/column in the master file that reads the same date.
View 2 Replies
View Related
May 18, 2006
I need help with a macro for copying and pasting of cells. I believe this should not be a problem for the Excel VBA experts, but for someone who can only record macro, I'm really at a loss.
Attached is a sample file, where sheet 'Source' is an example of the sheet from which data are to be copied. The other sheet, sheet 'Final' is an example of the final format that I need. The reason I'm doing this is I'm planning to upload my data into Access and so I need to convert them into a list format.
List of target columns in sheet 'Final' and source cells in sheet 'Source':
Column A: Biz ID - not sure if I really need this, by right it should be listed automatically once I paste the data
Column B: B2 of 'Source'
Column C: B2 of 'Source'
Column D: B1 of 'Source'
Column E: row 6, relevant column
column F: column K
column G: row 5, relevant column
column H: the specific amount
So basically I'm creating an entry for every amount in the table.
View 9 Replies
View Related
Aug 20, 2014
I've been tasked with separating data within an Excel cell into it's own row. The difficulty I am having is, I need to keep the ticket number each piece of data within that cell is linked to. For example, I have Column A that has the ticket number, and column I has the serial numbers of each piece of equipment linked to that ticket number. I would like the serial numbers separated into their own row, but still keep the ticket number in which that equipment is connected to.
Here's an example: Column A Column I
Ticket # Serial Numbers on Account
23999866 PAFR06598067 - MOPCUDTAM
Would I need a formula to do this, or is this something I can do using one of the Ribbon commands?
View 9 Replies
View Related
Sep 22, 2008
for example:
Column A.
@yahoo.com
@hotmail.com
@live.com
@msn.com
@yahoo.com
@hotmail.com
@live.com
@msn.com
how can i separate all datas by domain without having to cut and paste them manually.
View 7 Replies
View Related
Apr 25, 2009
Is there any formula or formatting that will list in a seperate table all names that occur equal to or more than a specified number of times?
eg: I have a list of names(below) that I want excel to go through and automatically place the recurring names in a seperate table on a seperate worksheet.
Gus
Bob
Mike
John
Gus
Nick
Mike
Gus
So Gus and Mike would be listed in the other table on the other worksheet.
View 9 Replies
View Related
Sep 21, 2013
I have a column with random times that are not seperated by any commas or spaces how can i seperate them into different columns. For example in A1 i have 12:3213:5420:32 this represent three different times 12.32 13.54 and 20.32 (each time has the same format as shown) and i want to display these as B1=12:32 C1=13:54 and D1=20:32 then do the same for the rest of column A?
View 3 Replies
View Related
Oct 29, 2013
I need some dates showing in the correct format.
I have two worksheets, the first will have a date as shown in the attached worksheet in cell A2. This would have been pasted as a value from another source. I need this to be seperated and to show as in cells D2 and E2.
Would be ok with either a formula or macro to do this.
View 2 Replies
View Related
Feb 26, 2013
I have a cell containing text like this
Ph(Off):* 5754112-5750441 ,* Cell:*0300-8406693*******,* Fax(Off):* 5712685*
I want to separate them into different cell though which every word or number contain his own cell
like
A1 = Ph(Off):* 5754112-5750441 ,* Cell:*0300-8406693*******,* Fax(Off):* 5712685
then i want it in this way
B1 C1 D1 E1 F1 G1
Ph(Off): 5754112-5750441 Cell: 0300-8406693 Fax(Off): 5712685
View 2 Replies
View Related
Dec 22, 2008
I have attached 2 spreadsheet :-
1. BounceBackMaster.xls
2. BouncebackMails.xls
I need to excute the macro from master file asking the input file. Input file will be the Mails spreadsheet. In the master spreadsheet there will be "TAG" column, depending on value it need to check the value in the Mails spreadsheet "MessageContent" column after subject value. It need to group all tAG value, each sheet need to be created with TAG value and related need to be copied from "BounceBack" sheet to created sheet.
Example:
Step 1 :- Macro is executed from "BounceBackMaster.xls" and asked for input file, input file will be "BouncebackMails.xls"
Step 2 :- From "BounceBackMaster.xls", First TAG value will be readed " Monthly Account Statement" is check in "BouncebackMails.xls"........
View 3 Replies
View Related
Dec 2, 2008
Seperating TEXT in different columns placed at non-fixed location in a cell...
I have some data which contains people's name and the places ( i.e Cities) mixed which I need to seperate, however the challenging part there is no consistency in data as the city can appear first in the middle , last or even just the city name in the cell but it needs to be seperated ...
In Column B I have the following type of DATA ...
View 11 Replies
View Related
Sep 26, 2011
I can’t seem to work out how to pull data relating to a particular title from one spreadsheet, to another, separating the information on.
For example, column A lists names, and column B lists tests scores for each person. However each person has done several tests, and the tests are listed in one cell, separated by a carriage return (not comma etc, so can't do a delimited function).
I want to create a new spreadsheet with names still in column A, but the test scores separated. So Column B = Test one, Column C = Test two, Column D = Test three, etc. In each column I would like only the test score listed (so not the test title - I will put this in the first row as the column header)
Is this possible?!
View 1 Replies
View Related
Jul 29, 2012
What I am looking for is a macro that can separate the data introduced manually in the left table (see attach file) and order it in the table from the right hand side as I have done it manually in this case. The base of it is to have at the end all the trips separated from days (days going from 0:00 hrs till 24:00 hrs). Maybe is a bit confusing but in the example I have attached I presume is going to be easier.
View 3 Replies
View Related
Jun 24, 2014
I want to separate the text into columns as in Table
Name
Name
Contract
Ref. No
[Code].....
View 5 Replies
View Related
Dec 1, 2008
A1 : Style 998 45702B WRAP DRESS 1 0 0 0 1
Try to accomplish:
I would like to remove the "1" in between "Dress" and "0"
in other word remove integer from string but starting from right only.
B1 = should contain 1
View 9 Replies
View Related
Jan 21, 2009
I have data in column with combination of alpha-numeric like "Member # 308166 RCI Number 4801-60436". can I split this without using copy and paste?
View 9 Replies
View Related
May 1, 2009
I have following kinds of texts in a column.
MISCELLANEOUS
EQUIPMENT
JBKU348597-3
T-225
75984
I want to convert above texts with space between every character as follows:
M I S C E L L A N E O U S
E Q U I P M E N T
J B K U 3 4 8 5 9 7 - 3
T - 2 2 5
7 5 9 8 4
View 9 Replies
View Related
Jul 20, 2009
I'm trying to separate text that have commas in between. I've got a column that contains commas and a few cells in those columns have commas and bracket. The problem occurs when there are more than two values WITHIN in the bracket that are separated by commas. How can parse the text in such a way where what ever is within the bracket remains in tact? For example: Controls, Motors, Transformers (LVoltage, High Performance, Medium Voltage). The goal is to separate everything before a comma but for Transformers I would like it to remain as 'Transformers (LVoltage, High Performance, Medium Voltage)'.
View 9 Replies
View Related