Free Microsoft Excel 2013 Quick Reference

How to add two text cells into one cell

Hello,

I tried to find this in the help section but was unable to locate it. Could you tell me how to add a name in one cell plus the name in another cell into one cell with the "&" sign between? So it would read "Don & Rose" in the final cell making the structure similar to:

Column A Column B
Row 1 Don Don & Rose Row 2 Rose

Thanks for your help!
Rick S


I have an actual sales data source, and budget sales data source, i need to
compare actual vs budget years, is there a way to merge two data source into
one pivot table?

I really need help on "How to split wrapped text in a single cell into
multiple lines" e.g

Text (wrapped) appear in one cell

Prepare and allow "Rentokil" anti termite treatment as described to sides
and bottom of foundation pit and basement beams trenches and all top surfaces
of lean concrete to basement floor area including apron and verandah.
Provide 5 years warranty.

Text splitted into four different cells

Prepare and allow "Rentokil" anti termite treatment as described to sides and

bottom of foundation pit and basement beams trenches and all top surfaces of
lean

concrete to basement floor area including apron and verandah. Provide 5
years

warranty.

I'm trying to paste text into ONE cell only. However, when I paste ("paste
special, text), it inserts the text into several cells.

I've previously copied entire resumes from Word docs and have had no problem
in pasting the info as text into one cell. I've never had to draw a text box
for this solution either.

I will be using an Excel template which will include thousands of copied and
pasted text entries. If drawing a text box is the answer, how can I format
cells in an entire column as text boxes?

Any help is greatly appreciated!

I'm trying to paste text into ONE cell only. However, when I paste ("paste
special, text), it inserts the text into several cells.

I've previously copied entire resumes from Word docs and have had no problem
in pasting the info as text into one cell. I've never had to draw a text box
for this solution either.

I will be using an Excel template which will include thousands of copied and
pasted text entries. If drawing a text box is the answer, how can I format
cells in an entire column as text boxes?

Any help is greatly appreciated!

Hi guys,

I am using MSoffice 2007, i want to add two numbers/ values in one cell, like top will be one value and bottom will be another value this will be coming from another location with formula.

Like the example :

24500/200 like this we have to display in one cell, as the top value will be added with =X+X+ and so on, same like that for bottom also, but the values will be different and have seprate .

Can any one help me out

Thanks

Hey there. I have a rather weird problem. I need to copy an entire row of data into one cell. Let me give you an example of what my output needs to be.

COLUMN A
AAAAA
AAAAB
AAAAC
AAAAD
AAAAE

The output I need in my one cell is:
AAAAA,AAAAB,AAAAC,AAAAD,AAAAE,

Is there an easy way to do this? I know it's strange, but unfortunately this is the output I need...

Thanks a ton!

Hello,

I need to combine the two following formulas in one cell.

=IF(ISNUMBER(SEARCH("Th",N3)),"Y","")and

=IF(ISBLANK(C4), "", C4)
Thanks!

I would like to combine the words from different cells into one cell -
sometimes 1 or 2 cells are left empty

Example
A1 A2 A3 A4 A5
Peter Simon Derek Empty Kent

combine into one cell marking all
=A1&","&A2&","&A3&","&A4&","&A5

Should say
Peter, Simon, Derek, Kent (without extra , or space for empty cell included)

Could somebody help me with formula for this? would be greatly appreciated

Q : How to know that character type in one cell of xls is more that s...
E.g How i will come to know that i typed more than specified charater, when
i am typing in that particular cell

Hi everyone!

I need to merge a group of cells into one cell, with all of the information intact, seperated by commas.

I know....concenate will do this. But this is my predicament.

I have a list of item numbers, and next to these item numbers are their OEM numbers. Each OEM has a separate cell, with the item number in the cell next to it. Some item numbers have more than one OEM, ranging anywhere from 2-5 of them. I can do a concenate, but that takes forever...there are over 8000 items.

Is there any way I can just select the OEM numbers in their cells, copy them, and paste them all into one cell, which will automatically separate each by a comma?

Hopefully there is a way to do this...

Thanks so much in advance!

See attached screen shot to see what I mean.

I need to somehow create a formula which will allow me to paste text from multiple cells into one cell (and also add a -dash- between each separate piece of text).

I'm sure this may be simple, but I'm afraid I must be too!

Any help greatly appreciated.

Momo (Scotland).

Column A has values Green, Red, Blue.
Column B has values Circle, Triangle, Square.
Column C has values 1, 2, 3.

What I wish to accomplish is that Column C has a value based on A and B relationship.

Example:
If Column A=Green and B=Circle, then C=1
If Column A=Red and B=Triangle, then C=2
If Column A=Blue and B=Square, then C=3
etc

If A and B have any other combinations, display no value.

I can make work if I use:
=IF(AND(A:A="Green";B:B="Circle");1)

BUT how do I add all conditions in one cell so whatever combination I need is automatically created?

I dont know what to put between two or more IF-clauses.
Semicolon is wrong:
=IF(AND(A:A="Green";B:B="Circle");1);IF(AND(A:A="Red";B:B="Triangle");2)

Any help is very much appreciated.

Cheers
Mafishas

Is it possible to combine the text in one Excel cell to another cell in the
same row? I need to combine the text of four or five cells into one cell
which would then contain the all the text of the other cells.

Hi,

I have 3 columns, one is Text, one is Date and the last is Time. I managed to combine the Date and Time cells and have them formatted properly but I can't figure out how to add my Text. So I am here for help. Attached is my original spreadsheet. I would like have all three cells combined into one with maybe about 4 or 5 spaces between each value. Then I would like to use the Paste Special - Values to remove the formulas so I can delete the 3 columns and just have 1 column.

Thank you for your help.

Hi.

I am trying to use mail merge to send out notification to employees on the details their expense claims had been processed for payment.

My database (pivottable) has a column that lists down all the expense claims document numbers and the total to be paid for all these expense claims added together. How do I create a formula to concatenate all the document numbers into one cell, given that the number of cells containing the document numbers vary from employee to employee? I have attached the file showing the format of my database (pivottable).

Thanks.

Dear Respected sir,
How to solve the following problem in Excel Worksheet?
In cell A1, there is a text ‘JAMES’
In cell A2, there is a text, ‘CALIFORNIA’
In cell A3, there is a number, ‘345678’
I would like to merge these multiple data values into one cell without ignoring any data.

Thanking you,
VASUDEVAN
vasudevanvelayudhan@yahoo.com

I'd like to combine several text cells into one cell seperated by a comma. There are over 50 cells per row and some are null, so would be keen to generate a formula I could copy down. Would prefer not to do a large concatenate with a trim?
Thoughts?

If i typed a whole paragraph into one cell of Excel, only a part of para show
up in that cell. I tried wrap text, increase the height of the column.
Nothing happen.
Any one have idea about it or there are some limit to view in Excel in one
cell

I am trying to copy data in multiple cells and paste it into one cell - is
this possible and if so how do I do it?

Thanks,

This should be a fairly simple one. I am trying to program a UserForm to accept text and paste it into a spreadsheet. I will then pass it to a macro that will sort it. The macro sorts it assuming the text is in 30 rows (when you paste the text into Excel manually it pastes it over 30 rows, not into A1)

However, I am not sure how to paste the text so that it is not just in A1 (which is what the code is doing).

This is my code thus far, not nearly completed though.

 Private Sub cmdcancel_Click()
    Unload Me
End Sub

Private Sub cmdaccept_Click()
    Dim RowCount As Long
    Dim ctl As Control

    RowCount = Worksheets("Input").Range("A1").CurrentRegion.Rows.Count
    With Worksheets("Input").Range("A1")
        .Value = Me.DataInput.Value

    End With

End Sub

Thoughts? I am not usually involved in VBA, but I am trying to save some time on repetitive processes.

I am trying to combine text that is in 4 different cells into one cell.

For Example:

D1 E1 F1 G1
FIRST FLOOR PAVING PLAN DRAWING

When combining these cells into one, you would get:

H1
FIRST FLOOR PAVING PLAN DRAWING

Is there a simple way to do this? Would it be a formula in H1? If so, what
formula?

Thanks for your help.

Brianna

I would like merge the contents in cell A1, B1 and C1 all into one cell in A1. Take a look at the picture below.
http://www.iimmgg.com/image/8c67e945...7a7516ef6063ff
In between the contents in A1, B1 and C1 there is “##” to separate each contents.

I would like to do this for the entire column A, B and C.

Important: Some cells are empty. e.g. B3 might be empty but A3 and C3 are not empty. So when merging the empty cell should be replaced with “?”. So the merged cell should look like "A3##?##C3" , See the image below:
http://www.iimmgg.com/image/495f7004...a912719659f96b

Part 2
I also would like to know the codes once these contents are merged, how to separate them like how it looked like initially.

I have attached a sample workbook
Sheet 1 contains a sample of texts.
Sheet 2 shows how the final outcome looks like for part 1.
Book11.xls

In the attached file, I created an example of a list I’m trying to break down and combine data from multiple cells into one cell. As it shows on sheet1, level 1 has two people who occupy it, Paul and Peter. I am trying to get the names Paul and Peter to be combined in one cell next to the #1 as shown on sheet2. I want it to put the correct amount of people next to their corresponding number as shown on sheet2. Is there anything that I can use that may make my life a little simpler? This will be done on a weekly basis, and incorporates a couple hundred items. Any help is appreciated.

Thanks.

I need to add two text cells together..

a1 b1
abc def

c1 abcdef