I am trying to create an CONCATEATE Formula

Microsoft Office 2007 home and student
March 6, 2012 at 04:31:55
Specs: Windows XP

I am trying to do the following. Cell A.: Word in Cell no brackets. Cell B I want to put Cell A and the following: (Created) in brackets. then i can do this for all Cells below.

Hope makes sense


See More: I am trying to create an CONCATEATE Formula

Report •

March 6, 2012 at 12:23:36
Hope makes sense


Post an example, before & after.



Report •

March 7, 2012 at 00:53:53
This is what i am trying to acheive Within one Cell Say

Cell A1: Room Power.

So Cell B1 should show: Room Power -(Done by Others)

Cell B1 : Room Power -(Done by Others)

Cheers Mark

Report •

March 7, 2012 at 05:54:53
In B1 enter the formula:

=A1&"( - Done by Others)"

or you can define your comments in another cell like Z1
so in cell Z1 you have the text string:
(Done by Others)
then do:




Report •

Related Solutions

Ask Question