showing text from more than one cells in one cell

G

Guest

how can i show the contents of two (or more) cells in one cell? For example, if i have a column of first names and one of last names, can i write a formula that will pull from the first and last name from each column and put it into one cell?
 
D

Dave Peterson

=a1 & " " & b1

Is one way.
how can i show the contents of two (or more) cells in one cell? For example, if i have a column of first names and one of last names, can i write a formula that will pull from the first and last name from each column and put it into one cell?
Click to expand...
 

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 Copy cells from one worksheet to another workseet - increment row & do again 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
VBA set thick borders around non empty cells in range 0
Last Modified By in a cell by user 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel 2 into 1 6
Excel Macro to hyperlink an archived worksheet to an index page 0
Excel Import Comments 3

Top