shrug-l: Adding a space when concatenating fields

Nonie Castro nonie_castro at coxtarget.com
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 lists.dep.state.fl.us
[mailto:shrug-l-bounces at lists.dep.state.fl.us
<mailto:shrug-l-bounces at lists.dep.state.fl.us> ] On Behalf Of Ken Stocks
Sent: Wednesday, February 28, 2007 3:55 PM
To: SHRUG
Subject: shrug-l: Adding a space when concatenating fields

Everyone,

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.
http://tools.search.yahoo.com/shortcuts/#news
<http://tools.search.yahoo.com/shortcuts/#news> 
_______________________________________________
SHRUG-L mailing list
SHRUG-L at lists.dep.state.fl.us
http://lists.dep.state.fl.us/mailman/listinfo/shrug-l
<http://lists.dep.state.fl.us/mailman/listinfo/shrug-l> 


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.dep.state.fl.us/pipermail/shrug-l/attachments/20070228/3de1e414/attachment.html


More information about the SHRUG-L mailing list