How to merge two columns & replace contents of cells conditionally?

		Microsoft Office Forums > Microsoft Excel > Excel
How to merge two columns & replace contents of cells conditionally?

FAQ

Mark Forums Read

Thread Tools

Display Modes

10-24-2012, 09:36 AM

mag

Windows 7 64bit How to merge two columns & replace contents of cells conditionally?

Office 2010 64bit

Novice

Join Date: Oct 2012

Posts: 11

How to merge two columns & replace contents of cells conditionally?

I have a challenge in MS-Excel 2010.

I have two columns that I need to merge and data in each cell overwritten conditionally (plz. see attached sample spreadsheet).

I am working on a key engagement and need to solve this ASAP, and greatly appreciate any help.

I believe my querry is pretty simple and can be solved by somebody and may take just a couple of mins. for someone here to suggest how to solve it.

Thanks a ton!

Attached Files

TEMP4-Last Names MERGE COLUMNS Test 2012-10-24.xlsx (84.7 KB, 11 views)

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
quick replace, sort, change columns	userman	Excel	1	05-01-2012 06:24 AM
merge cells	gsrikanth	Excel Programming	1	03-02-2012 10:58 PM
Concatenate/merge contents of multiple cells	PSYloco	Excel	2	05-14-2011 03:46 PM
Count range cells eliminating merge cells	danbenedek	Excel	0	06-15-2010 12:40 AM
Table of contents, remove spacing and put in 2 columns - need help urgently!	nam085	Word	1	03-04-2010 08:00 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:06 AM.