Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-24-2014, 08:37 AM
ketanco ketanco is offline display text from formula Windows 7 64bit display text from formula Office 2007
Expert
display text from formula
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default display text from formula

I want to display the text combined from few cells.



for example:

Lets assume, the contents of cells are follows, all contain text values:

A1: concrete
A2: footings
A3: excavation

Now, if I want the cell B10 to display

concrete, footings, excavation

how do i write that formula in B10?

of course when the contents of A1, A2, A3 change, the text displayed in B10 must change accordingly

Thanks
Reply With Quote
  #2  
Old 04-24-2014, 10:45 AM
gebobs gebobs is offline display text from formula Windows 7 64bit display text from formula Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

=a1 & ", " & a2 & ", " & a3
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Display paragraph of text based on value selected in combo WordWaza Word 0 08-09-2013 06:30 AM
Macro to display help text rusteinberg Word VBA 0 04-03-2013 09:55 AM
display text from formula If formula result is negative then display text oxicottin Excel 3 12-03-2012 02:12 AM
MS Word 2007 Won't Display Text Jess Wunman Word 1 03-06-2012 04:26 PM
display text from formula Outlook 2007 doesn't display plain text messages. forbeselderlaw Outlook 1 02-03-2010 02:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:23 PM.


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