|
|
|
|
#1
10-24-2012, 09:36 AM
|
|||
|
|||
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! 
|
|
#2
10-24-2012, 09:54 AM
|
||||
|
||||
Hi and welcome
Perhaps sthg like Code:
=IF(E2="-",B2&"",E2&"") Pull down as needed
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
|
|
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 |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode