| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine text data from 2 cells
simple question
a1 has brad b1 has glaberson i want c1 to be brad glaberson what is the formula, please thanks brad |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine text data from 2 cells
Brad, =CONCATENATE(A1," ",B1) or =A1&" "&B1 HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=542267 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine text data from 2 cells
Try this:
C1: =A1&" "&B1 Does that help? *********** Regards, Ron XL2002, WinXP "Brad" wrote: simple question a1 has brad b1 has glaberson i want c1 to be brad glaberson what is the formula, please thanks brad |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine text data from 2 cells
Perfect!!!
thanks guys "SteveG" wrote: Brad, =CONCATENATE(A1," ",B1) or =A1&" "&B1 HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=542267 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
| Combine 2 spreadsheets w/1 common column of data, text and number | Excel Worksheet Functions | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Linear Mode
