homepage Welcome to WebmasterWorld Guest from 23.23.57.144
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / WebmasterWorld / Webmaster General
Forum Library, Charter, Moderators: phranque

Webmaster General Forum

    
excel expert for affiliate.
wnshops

10+ Year Member



 
Msg#: 8281 posted 8:18 pm on Mar 30, 2005 (gmt 0)

help.
how can you merge two colums in to one colum.Excel 2004 Do we have any excel expert? Thanks

 

iblaine

10+ Year Member



 
Msg#: 8281 posted 8:56 pm on Mar 30, 2005 (gmt 0)

Merge Cell Wizard is an add-on that can do it but it's not free. I think the easiest way is to copy the cells into notepad. Wrap each line in notepad with quotes then copy back to excel. If you have ultraedit, then just go to search/replace all, turn regex on and replace ^p with "^p". Cells copied into a text editor will be delimited by a tab - so another way to merge cells is to get rid of the tabs then copy back into excel.

flobaby

10+ Year Member



 
Msg#: 8281 posted 9:17 pm on Mar 30, 2005 (gmt 0)

Just looked it up in the Excel help using the word "merge".

If you have something in A1 and B1 and want to combine to C1, put this in C1 (this takes the text from A1 and B1 and adds a space between the two.

=A1&" "&B1

Then just copy the formula in the rest of the C column by pulling the corner of C1 down.

If you want the merge to be a permanent value, just copy the results of the C column and Paste Special into a blank column using "values". That's it.

MrSpeed

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 8281 posted 9:19 pm on Mar 30, 2005 (gmt 0)

Insert a blank column in the spreadsheet and in the first row add a formula to concatenate the two columns you want. For example in Cell C1 add:
=A1&B1
Then drag the formula down the column to apply it to all the rows you want.

If you need a space try:
=A1&" "&B1

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / WebmasterWorld / Webmaster General
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved