Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Robert Judge
 
Posts: n/a
Default How to combine two columns?

I have received an EXCEL file that has two columns containing address
information. One column has the street number (for instance 6, 123, etc.)
and the second column has the Street name (Main, Elm, etc.)

In Excel 2003, how can I combine these two columns into one column to give
me, in the one column:
6 Main St.
123 Elm St.
  #2   Report Post  
Leigh Ann
 
Posts: n/a
Default

in a new column, use the formula: =A1&" "&B1 which will give you a join of
the two coumns with a space between the number and street name.

LAT

"Robert Judge" wrote:

I have received an EXCEL file that has two columns containing address
information. One column has the street number (for instance 6, 123, etc.)
and the second column has the Street name (Main, Elm, etc.)

In Excel 2003, how can I combine these two columns into one column to give
me, in the one column:
6 Main St.
123 Elm St.

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
how do I combine two forms with different size columns to make on. Morningside Excel Discussion (Misc queries) 3 April 17th 05 05:17 PM
How do you combine two columns to one? Help!!!!!! sttrumpet Excel Discussion (Misc queries) 2 March 23rd 05 02:04 AM
How do you combine two columns to one? StTrumpet Excel Discussion (Misc queries) 4 March 22nd 05 03:10 AM
combine columns RDB Excel Worksheet Functions 3 March 15th 05 05:07 PM
how do i combine columns in excel psamiam Excel Discussion (Misc queries) 2 December 6th 04 08:19 AM


All times are GMT +1. The time now is 02:18 PM.

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

About Us

"It's about Microsoft Excel"