| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Words in Excel Cells
I have three columns containing first, middle and last names respectively. Is
there a function that will allow me to show all three names as a text string cell? I have tried the concantate function and it works as far has putting the text in a string, but there are no spaces between the words. How do I get spaces between the words in the text string. Thanks, Butler from Tennessee |
|
#2
|
|||
|
|||
|
there are no spaces between the words. How do I get
spaces between the words in the text string. =A1&" "&B1&" "&C1 Rgds, Andy |
|
#3
|
|||
|
|||
|
Hi Andy,
Your information worked like a champ. Thanks a million for your help. Butler "Andy Brown" wrote: there are no spaces between the words. How do I get spaces between the words in the text string. =A1&" "&B1&" "&C1 Rgds, Andy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Creating a Microsoft Words document from an existing Excel spreads | New Users to Excel | |||
| linking cells in Excel 2003. How to not truncate to 255 characters. | Excel Discussion (Misc queries) | |||
| How do I password protect cells in a spreadsheet created in Excel | Excel Worksheet Functions | |||
| stop excel from shifting cells up when a query returns no data | Excel Worksheet Functions | |||
Linear Mode
