| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
combine cells
Hello, say you have Mindy in A1, Thomas in B1, how can you combine those in
C1 with a space between the names? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
combine cells
Mindy, here is one way,
=A1& " " & B1 -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Mindy" wrote in message ... Hello, say you have Mindy in A1, Thomas in B1, how can you combine those in C1 with a space between the names? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
combine cells
I'm sorry I forgot one column, so I have the formula as =A1&" "& B1" "& C1
but it doesn't like the B1. "Paul B" wrote: Mindy, here is one way, =A1& " " & B1 -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Mindy" wrote in message ... Hello, say you have Mindy in A1, Thomas in B1, how can you combine those in C1 with a space between the names? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
combine cells
Mindy, you need one more &,
=A1&" "& B1&" "& C1 -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Mindy" wrote in message ... I'm sorry I forgot one column, so I have the formula as =A1&" "& B1" "& C1 but it doesn't like the B1. "Paul B" wrote: Mindy, here is one way, =A1& " " & B1 -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Mindy" wrote in message ... Hello, say you have Mindy in A1, Thomas in B1, how can you combine those in C1 with a space between the names? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
combine cells
thanks
"Paul B" wrote: Mindy, you need one more &, =A1&" "& B1&" "& C1 -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Mindy" wrote in message ... I'm sorry I forgot one column, so I have the formula as =A1&" "& B1" "& C1 but it doesn't like the B1. "Paul B" wrote: Mindy, here is one way, =A1& " " & B1 -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Mindy" wrote in message ... Hello, say you have Mindy in A1, Thomas in B1, how can you combine those in C1 with a space between the names? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy & paste spreadsheet cells from excel to outlook to excel | Excel Discussion (Misc queries) | |||
| Use functions when cells are merged | Excel Worksheet Functions | |||
| Fill cells from non-adjacent cells | Excel Discussion (Misc queries) | |||
| Help adding text values | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Linear Mode
