Hi guys, not sure if this has been covered here before or not, but here is my si

Question

Hi guys, not sure if this has been covered here before or not, but here is my situation:

I have an excel document with a number of addresses, the columns include (Street Number, Street Name, City, State, Zipcode) so an address like;

411 Bleecker Street, New York, NY 10014

would be denoted as

(411, Bleecker Street, New York, NY, 10014) -> in reference to columns (Street Number, Street Name, City, State, Zipcode)

I want to be able to combine these so that they could be easily pasted into a mapping program, is there anyway to combine them automatically in excel into the form I need (or similar), it's great to have them all separated for analysis purposes but it would also be great to hhave them in an easy to view / use format as well. Is there anyway to do this with an automated Excel macc feature? Thanks,

Best!!!!

Explanation / Answer

One way, assuming the records begin in A2:

In any cell you wish (even a different sheet or workbook) use the formula:

=A2&B2&C2&D2&E2

Then copy it down for as may rows as necessary based on the number of records.

You can also then copy the results, then use Edit> Paste Special - Values to paste back into the the same cells to replace the formulas you created with the actual data, to a different range of cells, or to a different document.

Another opt#ion would be to use the Mail Merge feature of Word with your Excel file as the record source. That as well as others depenbds on what type of file format is required by the mapping prograam.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.