shrug-l: Adding a space when concatenating fields

Nonie Castro nonie_castro at
Wed Feb 28 16:34:04 EST 2007

=[cell reference]&" "&[next cell reference]

So it will be like this: =A2&" "&B2

-----Original Message-----
From: shrug-l-bounces at
[mailto:shrug-l-bounces at
<mailto:shrug-l-bounces at> ] On Behalf Of Ken Stocks
Sent: Wednesday, February 28, 2007 3:55 PM
Subject: shrug-l: Adding a space when concatenating fields


I am working with parcel attribute data in excel and trying to
concatenate two field (physical address numbers and road names).  I am
looking for a way to add a space between the two in the output. 

EX.  2324Bob Road or 2324 Bob Road

If any of you have suggestions on how to add the space while
concatenating, please let me know.

Ken Stocks
Gadsden County

8:00? 8:25? 8:40? Find a flick in no time with the Yahoo! Search movie
showtime shortcut.
SHRUG-L mailing list

-------------- next part --------------
An HTML attachment was scrubbed...

More information about the SHRUG-L mailing list