Excel

Closed
swati - Oct 1, 2009 at 10:39 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 1, 2009 at 09:40 PM
Hello,

m swati,m having problem in making data...
like i hv data as
A B C

centering and shuttering
including shuttering,
propping etc,

(a)foundations footingd,for mass 1 3


(b) pillars piers etc 2 2

I JUST WANT TO KNW HOW TO WRITE THIS FORMAT IN EXCEL.........
PLZ REPL ME 2DAY IF POSIIBL
Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Oct 1, 2009 at 09:40 PM
Swati your requirement is not clear.

for example
A1-centering
B1 --and
C1--shuttering

do you want to concatenate(add the three words) into another cell?
if this is so then in D1 type this formula
=A1&" "&B1&" "&C1

D1 will read "centering and shuttering"

plese clarify
0