<div>
If the zip codes in column C aren't formatted as text, you need to make sure that all five digits show up:<br />
&nbsp; =A1 &amp;&nbsp;&quot; &quot;&nbsp;&amp; B1 &amp;&nbsp;&quot; &quot;&nbsp;&amp; TEXT(C1, &quot;00000&quot;)
</div>


If the zip codes in column C aren't formatted as text, you need to make sure that all five digits show up:
  =A1 & " " & B1 & " " & TEXT(C1, "00000")

<div>
Did my suggested approaches help at all? /Ture
</div>


Did my suggested approaches help at all? /Ture

<div>
Yes it did work. &nbsp;Sorry for the delay. The only glitch was that out of 4 address columns, most used only 3 which resulted in a blank line in most of the imports. &nbsp;This I can live with. &nbsp;Thanks so much.
</div>


Yes it did work.  Sorry for the delay. The only glitch was that out of 4 address columns, most used only 3 which resulted in a blank line in most of the imports.  This I can live with.  Thanks so much.

<div>
<div class="content wysiwyg-content">
I need to combine 3 Excel text columns into one new column. &nbsp;I have a excel file that has three columns (City | State | zip) I need to combine these three columns into one with at least one space between them so the one column reads (City &nbsp;State &nbsp;Zip)<br />
<br />
The underlining reason I need to do this is for import into Quickbooks 2007 which formats the address fields as <br />
Address 1<br />
Address 2<br />
Address 3<br />
<br />
Thanks<br />
&nbsp;
</div>
</div>


I need to combine 3 Excel text columns into one new column.  I have a excel file that has three columns (City | State | zip) I need to combine these three columns into one with at least one space between them so the one column reads (City  State  Zip)

The underlining reason I need to do this is for import into Quickbooks 2007 which formats the address fields as 
Address 1
Address 2
Address 3

Thanks
 

Combine 3 excel text columns into 1 column,

This topic area includes legacy versions of Windows prior to Windows 2000: Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions including Windows Mobile.

Windows OS

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.