<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE></TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2912" name=GENERATOR></HEAD>
<BODY><!-- Converted from text/plain format -->
<P><FONT size=2><FONT face="Trebuchet MS">=[cell reference]<STRONG>&"
"&</STRONG>[next cell reference]<BR><BR>So it will be like this: <FONT
color=#ff0000><STRONG>=A2&" "&B2</STRONG></FONT><BR><BR>-----Original
Message-----<BR>From: shrug-l-bounces@lists.dep.state.fl.us [</FONT><A
href="mailto:shrug-l-bounces@lists.dep.state.fl.us"><FONT
face="Trebuchet MS">mailto:shrug-l-bounces@lists.dep.state.fl.us</FONT></A><FONT
face="Trebuchet MS">] On Behalf Of Ken Stocks<BR>Sent: Wednesday, February 28,
2007 3:55 PM<BR>To: SHRUG<BR>Subject: shrug-l: Adding a space when concatenating
fields<BR><BR>Everyone,<BR><BR>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. <BR><BR>EX. 2324Bob Road or 2324 Bob Road<BR><BR>If any of
you have suggestions on how to add the space while concatenating, please let me
know.<BR><BR>Ken Stocks<BR>Gadsden
County<BR><BR><BR><BR>____________________________________________________________________________________<BR>8:00?
8:25? 8:40? Find a flick in no time with the Yahoo! Search movie showtime
shortcut.<BR></FONT><A
href="http://tools.search.yahoo.com/shortcuts/#news"><FONT
face="Trebuchet MS">http://tools.search.yahoo.com/shortcuts/#news</FONT></A><BR><FONT
face="Trebuchet MS">_______________________________________________<BR>SHRUG-L
mailing list<BR>SHRUG-L@lists.dep.state.fl.us<BR></FONT><A
href="http://lists.dep.state.fl.us/mailman/listinfo/shrug-l"><FONT
face="Trebuchet MS">http://lists.dep.state.fl.us/mailman/listinfo/shrug-l</FONT></A><BR></FONT></P></BODY></HTML>