Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
taking data from multiple cells and displaying in one cell
I want to take data from multiple cells and display it as one. For example, we'd have a cell which will have the persons first name and another cell with the persons last name. Then, we'd have one cell that would take the first and last name and display it in one cell. How do I do this? Thanks in advance! -- djarcadian ------------------------------------------------------------------------ djarcadian's Profile: http://www.excelforum.com/member.php...o&userid=15877 View this thread: http://www.excelforum.com/showthread...hreadid=546851 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
taking data from multiple cells and displaying in one cell
=A1 & " " & B1 where A1 contains First name and B1 contains Last Name
e.g. A1=Joe B1=Bloggs C1=Joe Bloggs HTH "djarcadian" wrote: I want to take data from multiple cells and display it as one. For example, we'd have a cell which will have the persons first name and another cell with the persons last name. Then, we'd have one cell that would take the first and last name and display it in one cell. How do I do this? Thanks in advance! -- djarcadian ------------------------------------------------------------------------ djarcadian's Profile: http://www.excelforum.com/member.php...o&userid=15877 View this thread: http://www.excelforum.com/showthread...hreadid=546851 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
taking data from multiple cells and displaying in one cell
Thanks! :) -- djarcadian ------------------------------------------------------------------------ djarcadian's Profile: http://www.excelforum.com/member.php...o&userid=15877 View this thread: http://www.excelforum.com/showthread...hreadid=546851 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for displaying in 1 cell Lowest value from multiple other cells | Excel Worksheet Functions | |||
Blank cells and Charting multiple data points | Charts and Charting in Excel | |||
searching cells - displaying data | Excel Discussion (Misc queries) | |||
Displaying cell references next to embedded cells in Word 2000 | New Users to Excel | |||
Comparing Cells and Displaying Data | Excel Worksheet Functions |