| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you Concactenate Fields in Excel???
Can someone please tell me how to concactenate fields in Excel?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you Concactenate Fields in Excel???
Try this eg.
A1 = Red B1 = Apple Type the following in C1 =A1&B1 you get RedApple if you want a Space in between the two words type this in C1 =A1&" "&B1 "TotallyConfused" wrote: Can someone please tell me how to concactenate fields in Excel? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you Concactenate Fields in Excel???
Thank you so much. This forum is very much appreciated.
"claude jerry" wrote: Try this eg. A1 = Red B1 = Apple Type the following in C1 =A1&B1 you get RedApple if you want a Space in between the two words type this in C1 =A1&" "&B1 "TotallyConfused" wrote: Can someone please tell me how to concactenate fields in Excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I convert data with fields in rows to fields as columns | Excel Discussion (Misc queries) | |||
| Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
| number of fields in the row fields in pivot table | Excel Discussion (Misc queries) | |||
| Missing Zeros & Concactenate Failure | Excel Worksheet Functions | |||
| Need pie chart with number of fields instead of info in fields | Charts and Charting in Excel | |||
Linear Mode
