Cell data/text problems

[Svefnleysi]

I'm trying to put both text and cell value from another sheet in a single cell.

I've tried:
='sheet'!cell"text"
Doesn't work.

Also, I understand this is somehow it's supposed to be done
="Total: "&A12
But I need the cell data to be from another sheet and also I need the text to succeed the cell value.

Going by the above example, I tried:
='sheet'&cell"text"
But that also doesn't work.

Does anyone have any idea how (or if) I can do this?

Thanks.

[zbor]

Put in cell = go to some cell (in any sheet) and click it then put & and then next cell (etc)

For example =A1&'sheet'!B3

[teylyn]

Hi Sven,

try something like

=text(Sheet2!A1,"0.00")&" "&A1

This will take the number from Sheet2, cell A1, convert it to a text where the number has two decimal points and then add the text from cell A1 from the current sheet.

When you refer to a cell in another sheet, you need to use the syntax

Sheet2!A1

If the cell in the other sheet is a number and you want to apply a specific format to display the number, then use the TEXT() function to format the number into text

=TEXT(Sheet2!A1,"SKR #,##0.00")

as an example.

You can concatenate text values with the & sign.

If you want, post a sample of your data and mock up the expected result, then we can help you put a formula together. You can upload a file by clicking "Go Advanced" below the Quick Reply box and then the paper clip icon.

Note: depending on your locality, you may need to exchange the comma , for the semicolon ; in your formulas.

cheers

[Svefnleysi]

Thanks, guys. Turns out I was misinterpreting what the ampersand was there for. It works perfectly now.

[teylyn]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save