Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-05-2016, 12:49 PM
inreality01 inreality01 is offline Complex calculation from multiple sheets to master sheet Windows 7 64bit Complex calculation from multiple sheets to master sheet Office 2013
Advanced Beginner
Complex calculation from multiple sheets to master sheet
 
Join Date: Dec 2015
Posts: 34
inreality01 is on a distinguished road
Default

Can you also tell me how to do the following.......... which I know should be super easy I'm assuming.



I want to consolidate / join / "add" two text columns together so that a 3rd column contains all the data of the first two columns.

For the life of me I can't figure this out. I would think Excel would have a simple way to do this. I might try to do it with an Index function although it seems like there should be an easier way.

By the way, I'm looking for this to be dynamic so if either Column A or B change then Column C is updated without having to do anything.

This will be my last question.
Reply With Quote
  #2  
Old 01-05-2016, 02:53 PM
gebobs gebobs is offline Complex calculation from multiple sheets to master sheet Windows 7 64bit Complex calculation from multiple sheets to master sheet Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Quote:
Originally Posted by inreality01 View Post
I want to consolidate / join / "add" two text columns together so that a 3rd column contains all the data of the first two columns.
Which two columns?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Complex calculation from multiple sheets to master sheet Excel, transfer data from Master Sheet to sub sheets, using key word from column anvqui Excel Programming 9 06-16-2015 01:35 PM
Need help in automating data from multiple sheets into a single sheet veedee Excel Programming 8 06-12-2014 10:04 PM
Complex calculation from multiple sheets to master sheet Need help in automating data from multiple sheets into a single sheet veedee Excel 1 06-11-2014 04:01 AM
Combine Data From 2 Sheets into a new sheet bremen22 Excel 1 09-11-2013 12:59 PM
Complex calculation from multiple sheets to master sheet How do I merge data from one sheet in a workbook out into multiple sheets nolesca Excel 4 06-07-2010 08:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:30 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft