Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Macro to combine two cells into one

Hello: How could I combine cell H8 and E10 from the cost accounting Sheet to the Data sheet into one cell from D3 to D13. The code below only pastes E10 into the D3 to D13 range

H8=Name
E10= Address

D3=Name/Address

Sheets("Cost Accounting").Select
    Range("E10").Select
    Application.CutCopyMode = False
    Selection.Copy
    Sheets("Data").Select
    Range("D3:D13").Select
    ActiveSheet.Paste
Thanks


Post your answer or comment

comments powered by Disqus
Hi all
Is it possible to combine two chart into one chart in excel, What I mean is if I have below data:-
WW-----A-----------B
01-------400-------80
02-------550-------75
03------680--------125
04------475--------95

currently I have two chart showing the data, what I want is to have two chart into one which content
Y axis start from 300 to 800
another y axis start from 0 to 250
and only one X axis which is my ww...

Pls comment and help on this tks...

Hi
I have two ranges in my worksheet
One range is called From and contains a date
and the other range is called To and contains a date.
I'm trying to combine the two ranges into one cell on a different worksheet
and I get the number format of the dates instead of the dates taht are shown
in the ranges.

Here is the formula I'm using to combine the dates into one cell
=From&" - "&To
And.. here's the answer I'm getting:
37987 - 38353

How do I get these numbers to show as dates (like 1/1/2004 to 1/1/2005)
I have the cell formated to show as a date..but no luck..

Thanks in advance for your help!!
Kimberly

Hi! I'm using Excel 2000, trying to combine two worksheets into one with totals. Each worksheet is for a month (Jan and Feb), and has a column across the top with defect codes, and the rows contain part info, along with totals for each defect. I need to make a yearly worksheet that combines the defect totals on each sheet. However, the parts information and the defects on each worksheet are slightly different (one sheet has more parts and defect codes). I'm at my wit's end trying to think of how to do this - can anyone help!?!?!

Thank you!

I want to combine two worksheets into one summary worksheet so I can create a
pivot table to chart dates along x-axis and numbers y-axis, legends being
Open and Closed. My worksheet 1 consists of 2007 data and my second
worksheet consists of 2008 data. They have same labels.

Let's say A1 has value of 7, and B1 and value of 8,
I need a macro to copy both of them into a new cell of another sheet, let's say Sheet2!C1, and display it as 7&8.

Is it possible?

Thanks a lot!

hello everybody

i am using this macro
Sub Combine()
Dim J As Integer
On Error Resume Next
Sheets(1).Select
Worksheets.Add ' add a sheet in first place
Sheets(1).Name = "Combined"
For J = 2 To Sheets.Count ' from sheet 2 to last sheet
With Sheets(J).UsedRange
'Copy heading(1st row) only from Sheets(2)
' otherwise, copy from 2nd row
.Resize(.Rows.Count - IIf(J = 2, 1, 0)).Offset(IIf(J = 2, 1, 0)).Copy _
Sheets(1).Range("A65536").End(xlUp)(3)
End With
Next
End Sub

to move all worsheet into one . it is working 99% good the only thing thats not being transfered to "COMBINE" is the first line of sheet one only!!! . but everything else on that sheet 1 and the other sheet gets transfered.
can anyone assist me with this problem, or has a better macro to accomplish this task.

Using Excel 2003. I have two Excel files, each with a single worksheet
containing the data that I need to summarize. Each has a common field
containing an account number. I need to summarize data from each spreadsheet
into a single table. For example, I have account number, customer name, city
and state in one worksheet/file and dollar amounts on about 10% of those
customers in the other worksheet/file. Is it possible to combine this data
into a single Pivot Table from the two files? Or do I need to combine the
files into a single worksheet first and go from there? I am new to working
with Pivot Tables and do not know all the ins and outs of the feature.
Thanks for any help you can provide!

I have a spreadsheet with formulas that calculates
percentages and rankings. My boss wants to combine two
formulas into one. He wants to see the percentage and the
rank of that cell on the same line. Is there a way to
combine two different formulas into one?

Thanks for the help.

T.R.

I need to find out if there is a macro that can help me merge data in 400 cells into one, with the data being separated by a "; ". Let's say that these cells each contain 4 digits and the range is A1:A400. Thank you for any and all help in advance.

Using Excel 2003. I have two Excel files, each with a single worksheet
containing the data that I need to summarize. Each has a common field
containing an account number. I need to summarize data from each spreadsheet
into a single table. For example, I have account number, customer name, city
and state in one worksheet/file and dollar amounts on about 10% of those
customers in the other worksheet/file. Is it possible to combine this data
into a single Pivot Table from the two files? Or do I need to combine the
files into a single worksheet first and go from there? I am new to working
with Pivot Tables and do not know all the ins and outs of the feature.
Thanks for any help you can provide!

Hello - - Happy New Year to all!

I have a sample excel file that I'm trying to combine two formuals into one, taking a two step process into one. In Column A I have a number, like an account number that can be 5 digits or it can be 16. For example in A1 I have: 55556. What I have in cell B1 is
This removes the last digit, returning 5555 in cell B1.  In C1 I have:
, returning 000000000005555 (a 15 digit number).

Is there a way to combine these two formuals into one so I can have the 15 digit text in B1? Thanks for you help and thoughts!!!! Again, best wishes to all in 2011!!!!

I am working with excel and dealing with multiple spreadsheets. I am
configuring data for By Company Total, then into By Rep Total and now into By
Region Total. I have a region called CN. Within CN are are two reps and I
need to combine their data into one CN instead of CN1 and CN2. I am unsure as
to how to do this without messing up all the other data. I started to work on
it, but I think my way will take way too long and I figure there has got to
be an easier way. Could someone please assist me?

Combine Multiple Cells into One Based on another Cell

I have a two columns of data:

A|B
0.a|1
0.a|2
0.a|3

I need
A|B
0.a|1
|2 (same cell as 1, but alt+enter down)
|3 (same cell as 1, but all+enter down)

I am having some issues with cell formatting getting all messed up when combining cells. I am combining two cells into one with the below code:

Cell AB are zip codes, and AC is a country.  My problem is when I have a zip code that starts with zero, for example
AB450="07522" and AC450="USA", when they are combined it shows up as "7522 USA", I need it to
show "07522 USA".

I have cell AB450 formatted with NumberFormat = "00000", so when it is in AB450 it shows up with the zero in front. I am not sure how to select the specific data that I am combining in order to format it to keep the zero.

I am thinking I need something like the below code inserted, but I'm stuck.

    ????("????").Select
    Selection.NumberFormat = "00000"


What I need to do is turn two columns into one column, in the following format

Example,

AAA111           BBB222
I need the resulting new column value to be;

AAA111_BBB222

Is there any easy way to do this?

Thank you,

hi,
pls help my. how to combine 2 sheets into one sheet. Example below :

sheet1:
A B C
1 1 1
2 2 2

sheet2 :
D E F
1 2 3
3 2 1

sheet3(result) :
A B C D E F
1 1 1 1 2 3
2 2 2 3 2 1

Thanks..

I run into a problem on try to match 2 formula into one column, as I am trying to put in 2 difference brand product in to excel, as I try to sort out the brand of product quickly, I try to use the formula on common Letters on the serial no. and automatic input which brand name for me. and the formula I using is

HP
=INDEX(Lookup!$A$2:$F$50,MATCH(MID($C4,1,3),Lookup !$A$2:$A$50,0),2)

Dell
=INDEX(Lookup!$A$2:$F$50,MATCH(MID($C4,5,3),Lookup !$A$2:$A$50,0),2)

is there anyway to combine both formula into one column?

and I am looking for something like
HP "OR" Dell as result.

any help would be thankful

Nick Yee

Ok so I'm an EXCEL newb and would like to know how to combine these two formulas into one cell:

=CONCATENATE("TEXT")
=LEFT(B2,FIND(" ",B2)-1)

So the first word in another cell inserts after the text in the cell.

Any help would very much be appreciated. Thanks.

I have two cells with text in them but one to combine them into one. Example:

A1 Tom
A2 Bell

I want to combine this info into one cell to show it as A2 Tom Bell

??

Hi Everyone,

I have an annoying problem I can use some help one.

I have a worksheet with two columns (A and B), one is files names and one is path.

I want to combine these into one column but not as A+B.. it needs to be:
A1 = filename1
A2 = Path to filename1
A3 = filename2
A4 = Path to filename2
etc.

(there are several thousand rows otherwise i would just do it manually.)

thanks!

Hi everyone, it is my first post. Hope to find new way to learn Excel again.
In my work I need sometime to combine two column into one, but it is various location of column. Find somewhere on net macro that can do this but only first two column.

Sub AA()
Columns(3).Insert
Set rng = Range(Cells(1, 1), Cells(Rows.Count, 1).End(xlUp))
rng.Offset(0, 2).Formula = "=a1&""""&b1"
rng.Offset(0, 2).Formula = rng.Offset(0, 2).Value
rng.Resize(, 2).EntireColumn.Delete
End Sub Can somebody help me redo it to combine two selected columns into one with space between values and second column deleted?
Thank you.

Hello -

I am wanting to have a macro take approx. 200 Excel workbooks and
append them all into one workbook.

Facts:
* I have 200 workbooks each with it's own unique name. 1.xls,
2.xls, 3.xls, ... 200.xls.
* Each workbook contains only 1 worksheet
* Each workbook contains the same 4 column headings
* Workbooks all have different amount or rows
* Looking to combine everything regardless of duplicates into one
large workbook with the same 4 column headings.

Can anyone provide some newbie VBA code/Macro which could faster then
the old "cut and paste" method.

Thanks!

Hi,

Included in the newsample.xls file I have a table A1:W25 which is my starting point. I then run a macro called "Restructure" and it changes the data into a table that looks like X1:AS5

What I need is help modifiying the macro to include the values of the cells at the end of the assignment name. See a partially complete table in X7:AB8

Thanks in advance!

I am trying to combine multiple rows into one cell in a quick way and I'm not sure this is something that will be easy to do. I know about Concatenate, but it's not really what I want. . .

Here's what we're doing. I'm a software tester and whenever I make entries into our reservations system, I log everything to a log file. We can log to .txt or .xls but it's essentially text so every line goes one by one by one into Excel.

We generally have to take that log file and cut/paste the responses to the entries into Excel. The responses could be just a couple lines long or they could be several. And, it is formatted in such a way that Excel (if you save the file as .xls) reads each line as on entry.

Is there a way to select a range of a response, and put it into one cell? The only way I've found to do this is to highlight the range, CUT it and paste it into notepad, then highlight and cut it and paste it back into one cell and let the cell resize the information.

I appreciate your help!

Thanks,

Chris


No luck finding an answer? You could always try Google.