Excel experts -- I need help!

[DarcyLongfellow]

I've tried the "Help" feature and googling, and I can't seem to figure out if what I want to do is possible.

On Microsoft Excel, I currently have a document where every part of an address is a different column -- so it's:
Column A B C D E
Smith, Sally 123 South St. Anytown FL 12345

I need to turn these rows into address labels. Is there any way to turn Columns B, C, D, and E into one column? The only way I can find ("Merge and Center") deletes all the info except that in column B.

Alternatively, is there an easier way I'm not thinking of?? The thought of doing all these by copying and pasting 120 different addresses is depressing :-)

Thanks for any expertise :-)

[spankswife]

if the info is in A1 B1 C1, in D1 (or whereever you want it do it) =A1&B1&C1

[hocus]

Create a fomula where you have it like this:
=A1&""&B1&""&C1&""&D1&""&E1

[hocus]

Oct 10, 2012 15:37:27 GMT -5 hocus said:

Create a fomula where you have it like this:
=A1&""&B1&""&C1&""&D1&""&E1

There is also a CONCATENATE fucntion in excel. (2007 has it, I am not sure about earlier verions). It don't do the spacing, which I did in my formula.

[Deleted]

I'd do a mail merge in Word on the layout of labels you're using (Avery template or whatever).

[Deleted]

Oct 10, 2012 15:41:53 GMT -5 @tokenhoser said:

I'd do a mail merge in Word on the layout of labels you're using (Avery template or whatever).

This is what I was thinking. The way you have it set up currently is exactly how you would need it for a mail merge.

[DarcyLongfellow]

You ladies are awesome :-) Thank you so much!!

I knew there had to be a way, and I figured MM would know it!

Now, here's where I reveal the fact that I'm an excel idiot. How would I go about using a formula? Like, where would I put it in?

And, I assume I can do it for the whole spreadsheet at once? Like, the information is in columns B, C, D, and E of every row. So, I would want to merge (for example) B1, C1, D1, and E1 and also every other row through B120, C120, D120, and E120.

[DarcyLongfellow]

Oct 10, 2012 15:43:58 GMT -5 cuadrado said:

Oct 10, 2012 15:41:53 GMT -5 @tokenhoser said:

I'd do a mail merge in Word on the layout of labels you're using (Avery template or whatever).

This is what I was thinking. The way you have it set up currently is exactly how you would need it for a mail merge.

Really? Awesomeness. So much better than formulas on excel!!

An Avery template is exactly what I plan to do.

I have vague memories of using mail merge years ago, and I seem to remember it being very straight forward.

Off to try to figure it out now. Thank you all so much!!!!

[Deleted]

If you decide to do a formula, you'd put it in an empty column (or insert a column beside the ones you're combining).

But seriously think about doing a mail merge in word onto the label template. support.microsoft.com/kb/294684

[spankswife]

So in F, put =B1&C1&D1&E1 (assuming they start in row 1)

Then you can copy and paste it all the way down in col F, or if you click on F1 (after you enter the formula, on the bottom right corner is a little dot you can "grab" and just grab and pull it to the bottom

[dottyblue]

If you want it laid out like:
Smith, Sally
123 South St.
Anytown, FL 12345

You will need to do a mail merge directly to your mailing label template in Word using the excel spreadsheet as your data source.

If you want it to stay in excel and be formatted as the following:
Smith, Sally 123 South Street Anytown FL 12345

You would use the formula: =A1&""&B1&""&C1&""&D1&""&E1
Where there is a space between the quote marks (not obvious here by looking)

[DarcyLongfellow]

Oct 10, 2012 15:46:47 GMT -5 @tokenhoser said:

But seriously think about doing a mail merge in word onto the label template. support.microsoft.com/kb/294684

This is exactly what I need. Thank you SO much!!!

You ladies are all awesome -- thank you!!!

[Deleted]

Now I need an ARC-GIS expert... any takers?