Value error on simple formula

[Carty]

HI.

I'm using Excel 2013 where the file type is .xlsx

using this

='tab name'!E30

returns the (correct)value 50
However if I use this

='tab name'!e30&" Slices"

I get a value error where I am expecting "50 Slices".
If I use the formula evaluating tool it resolves to "50 slices" but the next stage returns #VALUE

I have had problems before with corrupt sheets where this

="12345"+0

returns the wrong result but this sheet does not suffer from this.
If I open a newworkbook the formula returns the correct result. This again points to a dodgy sheet but how do I go about checking this?
If the original book was created using excel 97 (.xls) and then saved as excel 13 would this stop the formula working?

So many questions, so little ideas

Thanks

Paul

 

[wilsjohn]

='tab name'!e30&" " &Slices

try this

 

[wilsjohn]

wait is slices a string or a cell name?

 

[wilsjohn]

=Sheet2!E30 & " Slices"

worked for me

 

[Carty]

Hi wilsjohn
Thanks for your replies.I have entered the following but all return a value error:
='tab name'!E30&" " &Slices
='tab name'!E30 & " Slices"
=tab name!E30 & " Slices"
By the way " Slices" is just text that needs to be added to the value in E30

 

[Joe4]

Your original formula of:

='tab name'!e30&" Slices"

worked fine for me too. It is a pretty basic/standard formula. I prefer to use spaces in between the parts of my formula, like this:

='tab name'!e30 & " Slices"

But I really don't think that should matter.

Some alternative formulas you can try:

=CONCATENATE('tab name'!E30," Slices")

and

=INDIRECT("'tab name'!E30") & " Slices"

They should all return the same thing.

If it does not work, then perhaps you have some corruption in your original workbook.

 

[Carty]

Hi Joe4

It's the sheet

Opened a new book, made 1 sheet look at the other and everything is good in the world!

Thanks for your ideas

Paul