| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I merge column contents
Here is my scenario:
I have column A (first name) and column B (last name). I need to merge the to column a (first and last name). Ho do I accomplish this? Using Excel 2003 Sorry for what seems like a stupdily simple question! Mike Biang ASP/PHP/ASP.NET |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I merge column contents
"Mike" wrote in message oups.com... Here is my scenario: I have column A (first name) and column B (last name). I need to merge the to column a (first and last name). Ho do I accomplish this? Using Excel 2003 Sorry for what seems like a stupdily simple question! Mike Biang ASP/PHP/ASP.NET =CONCATENATE(A3," ",B3) That takes the value in A3, adds a space (shown between quotation marks), and finally adds the value in B3. If you then copy the formula all the way down the column, Excel will automatically change the line numbers (A3 to A4, A5, etc). There's a way to stop that automation, but in this case, you want it. This formula has to go in a separate column, but if you have room in the viewable part of the sheet, you can stick the new column way off to the right somewhere. Then, copy the new, joined names into whatever column you want, using Edit, Paste Special, Values. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I merge column contents
hi! let us assume first name in A1, last name in B1 in C1 enter =A1&B1 which will give the full name! -via135 Mike Wrote: Here is my scenario: I have column A (first name) and column B (last name). I need to merge the to column a (first and last name). Ho do I accomplish this? Using Excel 2003 Sorry for what seems like a stupdily simple question! Mike Biang ASP/PHP/ASP.NET -- via135 ------------------------------------------------------------------------ via135's Profile: http://www.excelforum.com/member.php...o&userid=26725 View this thread: http://www.excelforum.com/showthread...hreadid=513761 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I merge column contents
No such thing as a stupdi question.
Insert a new column to the left of A: this will be column A, first name is now column B, last name is now column C. In the first relevant cell of column A (call it A1), enter this formula: =B1&" "&C1 This merges the value of B1 and C1 with a space in between. If you need to convert this to text, highlight all of column A, copy it to the clipboard, then click Edit Paste Special, select Values, and click OK. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I merge column contents
"Doug Kanter" wrote in message ... "Mike" wrote in message oups.com... Here is my scenario: I have column A (first name) and column B (last name). I need to merge the to column a (first and last name). Ho do I accomplish this? Using Excel 2003 Sorry for what seems like a stupdily simple question! Mike Biang ASP/PHP/ASP.NET =CONCATENATE(A3," ",B3) That takes the value in A3, adds a space (shown between quotation marks), and finally adds the value in B3. If you then copy the formula all the way down the column, Excel will automatically change the line numbers (A3 to A4, A5, etc). There's a way to stop that automation, but in this case, you want it. This formula has to go in a separate column, but if you have room in the viewable part of the sheet, you can stick the new column way off to the right somewhere. Then, copy the new, joined names into whatever column you want, using Edit, Paste Special, Values. Oops - type. Should've said "but if you DON'T have room..." |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I merge column contents
Thanks you guys. You Rock
Mike Biang ASP/PHP/ASP.NET |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I merge column contents
"via135" wrote in
message ... hi! let us assume first name in A1, last name in B1 in C1 enter =A1&B1 which will give the full name! -via135 He might like to have a space between the names. Can your method do that? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I merge column contents
hi Doug! thks for pointing out! -via135 Doug Kanter Wrote: "via135" wrote in message ... hi! let us assume first name in A1, last name in B1 in C1 enter =A1&B1 which will give the full name! -via135 He might like to have a space between the names. Can your method do that? -- via135 ------------------------------------------------------------------------ via135's Profile: http://www.excelforum.com/member.php...o&userid=26725 View this thread: http://www.excelforum.com/showthread...hreadid=513761 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I merge column contents
You're welcome. How is it done using that method you provided?
"via135" wrote in message ... hi Doug! thks for pointing out! -via135 Doug Kanter Wrote: "via135" wrote in message ... hi! let us assume first name in A1, last name in B1 in C1 enter =A1&B1 which will give the full name! -via135 He might like to have a space between the names. Can your method do that? -- via135 ------------------------------------------------------------------------ via135's Profile: http://www.excelforum.com/member.php...o&userid=26725 View this thread: http://www.excelforum.com/showthread...hreadid=513761 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| merge data from multiple columns to single column | Excel Worksheet Functions | |||
| Copying the contents of a column into a chart | Excel Worksheet Functions | |||
Linear Mode
