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

Thread Tools

Display Modes

10-24-2012, 09:54 AM

Pecoflyer

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

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Hi and welcome

Perhaps sthg like

Code:

 =IF(E2="-",B2&"",E2&"")

in F2?

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

« Previous Thread | Next Thread »

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 10:26 PM.