Thread: Insert Space
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sabegirl
 
Posts: n/a
Default 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