HELLLLP!!!..Anyone an expert with Excel Documents

[skybeergodd 0]

I am in desperate need of help. I have an Excel document and I need to merge two columns together. What I have now is a document with columns A, B,C,D,E,andF and I need to merge the information in columns C and D and end up with a document that is A,B,C,D and E.
Can anyone help me with this???

[mnealtx 0]

Linky love

Mike
I love you, Shannon and Jim.
POPS 9708 , SCR 14706

[ZigZagMarquis 9]

On the top right of the task bar...

Click on "HELP"

In the drop down, click on "Microsoft Excel Help"

(or just hit F1)

In the Assistance / Search for Window, search on "Merge the contents of multiple cells into one cell"... click the green arrow to the right to search

Click on "Merge or split cells or cell contents"

Under "What do you want to do"... click on "Merge the contents of multiple cells into one cell"

Read!

Good luck

[skybeergodd 0]

OK...let me clarify, I have Excel 2007 and I do not want to lose or have to retype all the data....what I have are address' column C has the numerics and Column D has the street names...I want to merger those two columns into a single column C with numerics and street names together.....If anyone can do that please either let me know how for PM me here and I can send you the file so you can work your magic. I'm just getting incredibly frustrated trying this.

[theonlyski 8]

Quote

OK...let me clarify, I have Excel 2007 and I do not want to lose or have to retype all the data....what I have are address' column C has the numerics and Column D has the street names...I want to merger those two columns into a single column C with numerics and street names together.....If anyone can do that please either let me know how for PM me here and I can send you the file so you can work your magic. I'm just getting incredibly frustrated trying this.

How big of a file are we talking about? I dont see any easy way to do it in excel, but if you really need it, I might be able to write something to make it work and just send me the file, Ill see what I can do.


ETA: Yeah, didnt look at Mikes link... that should work for you, if it doesnt, try using "=concatenate(x1," ",y1).

I guess Im just looking for shit to write a program for...

"I may be a dirty pirate hooker...but I'm not about to go stand on the corner." iluvtofly
DPH -7, TDS 578, Muff 5153, SCR 14890
I'm an asshole, and I approve this message

[mnealtx 0]

Did you read the link in my other post? It shows you how to do it.

Mike
I love you, Shannon and Jim.
POPS 9708 , SCR 14706

[mnealtx 0]

Quote

I guess Im just looking for shit to write a program for...

Bored today, ski?

Mike
I love you, Shannon and Jim.
POPS 9708 , SCR 14706

[theonlyski 8]

Quote

Quote

I guess Im just looking for shit to write a program for...

Bored today, ski?

What gave it away?

"I may be a dirty pirate hooker...but I'm not about to go stand on the corner." iluvtofly
DPH -7, TDS 578, Muff 5153, SCR 14890
I'm an asshole, and I approve this message

[skybeergodd 0]

PM sent with file attached. I tried both methods that were suggested. I just could not make them work, I kept losing one half of the data. I good with e-mail and internet porn but thats about the extent of my computer skills...lol

[mnealtx 0]

Quote

Quote

Quote

I guess Im just looking for shit to write a program for...

Bored today, ski?

What gave it away?

Lucky guess....

Mike
I love you, Shannon and Jim.
POPS 9708 , SCR 14706

[theonlyski 8]

yeah, that was a bit of a pain in the ass, but I got it to work, check your pm box

On a side note, I figured my Core2 Duo 2.4 GHz processor with 4gb ram would have been able to manipulate that data a little bit faster... It took me more time because the excel kept crapping out on me than it did to just fix it a different way.

"I may be a dirty pirate hooker...but I'm not about to go stand on the corner." iluvtofly
DPH -7, TDS 578, Muff 5153, SCR 14890
I'm an asshole, and I approve this message

[skybeergodd 0]

Thanks alot for the help. That just saved me a lot of time and frustration.

[Nataly 38]

A simpler way than concatenate is simply to go to a blank column and type:

=C1&D1

It will merge the info from the two columns into the new column. If you want a space between the two bit of info, try:

=C1&" "&D1

Or if you want a dash in between:

=C1&" - "&D1

The number "1" needs to be whatever row you are on.. Copy/paste-value the new column, delete C and D and insert your new info. If you get into trouble: CTRL+Z (undo!).

"There is no problem so bad you can't make it worse."
- Chris Hadfield
« Sors le martinet et flagelle toi indigne contrôleuse de gestion. »
- my boss

[billeisele 130]

Quote

A simpler way than concatenate is simply to go to a blank column and type:

=C1&D1

It will merge the info from the two columns into the new column. If you want a space between the two bit of info, try:

=C1&" "&D1

Or if you want a dash in between:

=C1&" - "&D1

The number "1" needs to be whatever row you are on.. Copy/paste-value the new column, delete C and D and insert your new info. If you get into trouble: CTRL+Z (undo!).

why would any guy want to do something the easy way if there is a hard way that looks more macho??

Give one city to the thugs so they can all live together. I vote for Chicago where they have strict gun laws.

[kallend 2,150]

Quote

A simpler way than concatenate is simply to go to a blank column and type:

=C1&D1

It will merge the info from the two columns into the new column. If you want a space between the two bit of info, try:

=C1&" "&D1

Or if you want a dash in between:

=C1&" - "&D1

The number "1" needs to be whatever row you are on.. Copy/paste-value the new column, delete C and D and insert your new info. If you get into trouble: CTRL+Z (undo!).

Well, GEE, whoever would have thought that to do a concatenation you'd use the concatenation operator?

www.mrexcel.com/tip074.shtml

...

The only sure way to survive a canopy collision is not to have one.

[ZigZagMarquis 9]

Quote

A simpler way than concatenate is simply to go to a blank column and type:

=C1&D1

It will merge the info from the two columns into the new column. If you want a space between the two bit of info, try:

=C1&" "&D1

Or if you want a dash in between:

=C1&" - "&D1

The number "1" needs to be whatever row you are on.. Copy/paste-value the new column, delete C and D and insert your new info. If you get into trouble: CTRL+Z (undo!).

Yeah... but... but that's "hard", Nat! Most people don't want to RTFM!!!

[skybeergodd 0]

My problem isn't just 1 row or column....I had over 4000 rows in the C and D columns that needed to be merged. Doing that 1 row at a time would have taken forever.

[ZigZagMarquis 9]

* slaps forehead *

You really have no idea what you're doing? Right?

Do what Nataly said for the first row and then copy / paste into the subsequent rows. Excel will fix it for you.

[Nataly 38]

Quote

* slaps forehead *

You really have no idea what you're doing? Right?

Do what Nataly said for the first row and then copy / paste into the subsequent rows. Excel will fix it for you.

Or double-click on the bottom right-hand corner of the cell with the formula.. It will flow down the 4000 rows on its own.


Edit to say: of course the OP has no idea.. Hence the question. Not everyone has used Excel before..

"There is no problem so bad you can't make it worse."
- Chris Hadfield
« Sors le martinet et flagelle toi indigne contrôleuse de gestion. »
- my boss

[ZigZagMarquis 9]

See the enclosed example. I think this is what you're trying to do. Set up the formula for the first set of rows and then copy paste into the remaining, Exel fixes the row numbers for you.

[ZigZagMarquis 9]

http://www.amazon.com/Excel-2007-Dummies-Greg-Harvey/dp/0470037377/ref=sr_1_1?ie=UTF8&s=books&qid=1276441514&sr=8-1-spell

[skybeergodd 0]

You hit the nail on the head....I really have no clue, all your computer talk might as well be in japanese. I have spent days hitting the help button, following commands ect. ect. and it's just never worked. There is always one small little detail thats left out or "doesn't apply in this particular situation" that screws everything up. computers are not an area of expertise for me. I mean I can write out directions on how to place a surgical airway and I can follow those direction without a problem, but those same directions would be meaningless to someone without a base knowledge of anatomy and general surgery.

[kallend 2,150]

You don't need to do it one row at a time. You can drag the formula down the entire length of the column with the mouse.

...

The only sure way to survive a canopy collision is not to have one.

[Hellis 0]

Problem solved??

Heres what you need. (Try it first on a copy of your workbook)

Hit ALT + F11

Insert -> Module

Paste the following code:

Sub merge()



LastRow = Range("A" & Rows.Count).End(xlUp).Row


For a = 1 To LastRow Step 1

Range("C" & a).Value = Range("C" & a).Value & " " & Range("D" & a).Value

Next a

Columns(4).Delete


End Sub

Hit F5

Delete the code again (otherwise excel will say the workbook has macros bla bla bla...)

Close the Window (Microsoft Visual basic)

Now you should see the sheet with column C and D merged and columnd D deleted.