Thread
:
Insert Space
View Single Post
#
3
Posted to microsoft.public.excel.misc
Ardus Petus
Posts: n/a
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
Reply With Quote