Thread: Insert Space
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ardus Petus
 
Posts: n/a
Default Insert Space

=A1&" "&B1

HTH
--
AP

"sabegirl" a écrit
dans le message de news:
...

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