| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Space
I Have Two Cells With Data. A1 Hot B1 Dog I Need To Get C1 To Read Hot Dog With A Space Between Hot And Dog. I Know How To Get The A1 And B1 To Read Hotdog Can't Get The Space Between The Two Words. I Have Keyed =a1&b1 In C1 But Cant Figure Out The Rest Of The Formula. Thanks For Your Help. -- sabegirl ------------------------------------------------------------------------ sabegirl's Profile: http://www.excelforum.com/member.php...o&userid=33982 View this thread: http://www.excelforum.com/showthread...hreadid=546233 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insert Space
Hi SabreGirl,
Try: = A1 & " " & B1 --- Regards, Norman "sabegirl" wrote in message ... I Have Two Cells With Data. A1 Hot B1 Dog I Need To Get C1 To Read Hot Dog With A Space Between Hot And Dog. I Know How To Get The A1 And B1 To Read Hotdog Can't Get The Space Between The Two Words. I Have Keyed =a1&b1 In C1 But Cant Figure Out The Rest Of The Formula. Thanks For Your Help. -- sabegirl ------------------------------------------------------------------------ sabegirl's Profile: http://www.excelforum.com/member.php...o&userid=33982 View this thread: http://www.excelforum.com/showthread...hreadid=546233 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I insert space between 2 consecutive columns of an XL Shee. | Excel Discussion (Misc queries) | |||
| insert picture | Excel Discussion (Misc queries) | |||
| space between text strings with concatenate | Excel Discussion (Misc queries) | |||
| Challenging Charting | Charts and Charting in Excel | |||
| insert a space in a phone #. change (123)456-7890 to (123) 456-78 | Excel Worksheet Functions | |||
Linear Mode
