#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=a1 & ", " & a2 & ", " & a3
|
|
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 |
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 |
Outlook 2007 doesn't display plain text messages. | forbeselderlaw | Outlook | 1 | 02-03-2010 02:42 AM |