Excel Cells

  • Thread starter Thread starter xenter
  • Start date Start date
X

xenter

I am using Excel 2003. Is there any way to take two different cells and
paste them into 1 cell. Ex:Column A Row 1(QA36) Column B Row 1 (.B67) and
put them both in
Column C Row 1.
Thank You
Terri Smith
(e-mail address removed)
 
Do you just want them to display together, and update when A1 and B1 are
updated?

C1: =A1 & B1

or

C1: =A1 & " " & B1


To paste them, select A1 & B1, select C1, click in the formula bar or
double-click in the cell (depending on your option settings) and paste.
That will insert a space between the A1 and B1 values.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
counting blank cells within two columns 2
Remove date format? 3
Concatenating adjacent cells ignoring blanks and adding a delimite 3
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Excel Concatenate with line breaks but ignore blank cells 3
Set default cell format while retaining overrides 3
07 Pivot Table side by side row labels 3

Back
Top