July 2009 Weddings
Dear Community,
Our tech team has launched updates to The Nest today. As a result of these updates, members of the Nest Community will need to change their password in order to continue participating in the community. In addition, The Nest community member's avatars will be replaced with generic default avatars. If you wish to revert to your original avatar, you will need to re-upload it via The Nest.
If you have questions about this, please email help@theknot.com.
Thank you.
Note: This only affects The Nest's community members and will not affect members on The Bump or The Knot.
Our tech team has launched updates to The Nest today. As a result of these updates, members of the Nest Community will need to change their password in order to continue participating in the community. In addition, The Nest community member's avatars will be replaced with generic default avatars. If you wish to revert to your original avatar, you will need to re-upload it via The Nest.
If you have questions about this, please email help@theknot.com.
Thank you.
Note: This only affects The Nest's community members and will not affect members on The Bump or The Knot.
Re: Anyone really good at Excel? Or converting data from Excel?
The job is to create an address directory. The publications department already has the directory set up from years past, but the guy who used to convert the files from xcel into a useable form for the directory is no longer here. And we don't know what he did.
My original file is an xcel file... We need to take that data to make a directory of it. I have lists of names, addresses, birthdays, emails, and some other info all in rows in separate columns (ie: A is last name, B is first name, C is street addy, D is city state zip, etc).
I need to take these and turn them from rows into columns. I managed to convert them all into separate columns by pasting special and choosing to transpose them. So everything in row 1 is now column A, row 2 is column B and so on.
But now I need to take each of those separate columns and put them into 1 column. I would normal just copy/ paste, but there are over 300 names/ columns and I don't have the time to do that.
After I do that, I need to then convert xcel to a text file, which I know how to do... it's just the getting it into one column that has me stumped.
So yeah. I'm kinda stuck right now. And I'll take any "Brittany, you are an idiot, there is a much easier way to do that" that you have.
This is what she said:
If the first name is in column A and the last name is column B to put them together in column C the formula would be: =A1&? ?&B1