Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jeff
 
Posts: n/a
Default space between text strings with concatenate

I'm using the concatenate function to join two bits of text - but I want a
space between, and the function joins them together without a space. How
can I insert a space into the resulting text please? (It seems to me that
we would want such a space in ANY two text strings which we join together
with concatenate - wouldn't we?? Why doesn't it put one in by default?!)

Thanks
Jeff


  #2   Report Post  
Niek Otten
 
Posts: n/a
Default

Hi Jeff,

=text1&" "&text2

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Jeff" <no_em@ilplease wrote in message ...
I'm using the concatenate function to join two bits of text - but I want a
space between, and the function joins them together without a space. How
can I insert a space into the resulting text please? (It seems to me that
we would want such a space in ANY two text strings which we join together
with concatenate - wouldn't we?? Why doesn't it put one in by default?!)

Thanks
Jeff



  #3   Report Post  
Jason Morin
 
Posts: n/a
Default

CONCATENATE is a worthless function. You can join text
strings using the ampersand (&). To add a space, use:

=A1&" "&A2

HTH
Jason
Atlanta, GA

-----Original Message-----
I'm using the concatenate function to join two bits of

text - but I want a
space between, and the function joins them together

without a space. How
can I insert a space into the resulting text please?

(It seems to me that
we would want such a space in ANY two text strings which

we join together
with concatenate - wouldn't we?? Why doesn't it put one

in by default?!)

Thanks
Jeff


.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compare cells/columns and highlight matching text strings luxbelle Excel Worksheet Functions 1 February 25th 05 06:34 PM
How do I clear blank space at the top of a word-wrapped text cell? mirage1210 Excel Discussion (Misc queries) 2 February 11th 05 09:19 PM
concatenate text and date Tara Keane Excel Discussion (Misc queries) 2 February 11th 05 05:17 PM
How to make a cell recognize multiple text strings? Tourcat Excel Worksheet Functions 1 February 8th 05 08:29 PM
Filter long Text strings Cimorene Excel Worksheet Functions 0 December 1st 04 04:01 AM


All times are GMT +1. The time now is 08:10 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"