Problem referencing data in cell linked to chart title

[Mark McInerney]

I have data in cell A1 that I am using as the chart title. I also want to add some text.

e.g.

=a1&"test"

Is this possible? I keep getting errors back??

Thanks for any help - appreciated.

 

[Tyron]

I have data in cell A1 that I am using as the chart title. I also want to add some text.

e.g.

=a1&"test"

Is this possible? I keep getting errors back??

Thanks for any help - appreciated.

Hey Mark McInerney,

What verison of Excel are you using?
What is the value of a1?

I am using Excel 2013 and =a1&"test" works. Using the below value of 5 for a1 I get the result of 5test.

if the value of a1 is 5 for example and you wanted to combine it with the word "test" then another way you could do this is to just use =CONCATENATE(A1, "test")

The result would be "5test"

later

Ty

 

[Mark McInerney]

Hi - Thanks for having a look...

Here is my reference:

='Master Overall Performance Shee'!$B$1&"Gross Margin"

Still getting error?

 

[Tyron]

Hi - Thanks for having a look...

Here is my reference:

='Master Overall Performance Shee'!$B$1&"Gross Margin"

Still getting error?

Okay. So I created a new workbook just now and put in two sheets.

First sheet is "Master Overall Performance Shee".
Second Sheet is Test answer. Using your exact formula which I plugged into A1 of the sheet called Test answer I was successfull in getting the result of 65Gross Margin. 65 is the value I placed into B1 of the MOP sheet.

Okay I am stumped as to why it isn't working for you. Okay an alternate is to go into the MOP sheet and select the B1 cell. Then name the cell. Then go into the second sheet and type:

=(Value2&"Gross Margin")

Hopefully this will work. If not then try the following:
1. type the formula into a blank text file.
2. highlight the new typed formula in the text file.
3. Copy and paste into the cell.

I sometimes do this in order to remove spaces or make sure I have typed the formula correctly.

Hope this helps.

Ty

 

[Mark McInerney]

Thanks Tyron - Will give it a go - very strange??