insert a symbol into a function cell

[Guest]

I am trying to merge two cells together from a different worksheet with the
values separated by the plus/minus symbol into one cell. I would also like
to retain the auto-update portion of if those values change in that sheet
they will in this new worksheet as well...

For clarity, I am trying to merge a mean and sd from two separate columns...
Using Excel 07 - Any suggestions would be super!

 

[Guest]

Try using this =text(sheet2!a1,"general")&"+"&text(sheet2!a2,"general")

 

[Guest]

Thanks Martin,

That works with "+" but I am actually trying to insert the symbol "±".
Seems once you invoke the function (=) feature the use of symbols or special
characters is prohibited?

 

[Guest]

Try:
="±"&TEXT(Sheet2!A1,"general")&"±"&TEXT(Sheet2!A2,"general")
(i just copied the character from your email)

or

=CHAR(241)&TEXT(Sheet2!A1,"general")&CHAR(241)&TEXT(Sheet2!A2,"general")


Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.

 

[Gord Dibben]

Krista

Add it to the formula.

=text(sheet2!a1,"general")&CHAR(177)&text(sheet2!a2,"general")


Gord Dibben MS Excel MVP

 

[Guest]

It works using the & CHAR() function! Although it automatically increases
the values to 8 decimal places...

Thanks for your help! Much appreciated.

 

[Guest]

Thanks Gord - any reason why I can no longer format the values to 2 decimal
places? I am returned 429.48689375 ± 470.313519234978 even though the cells

 

[Guest]

Krista,

use the following instead of "general" with the quotes
"#,##0.00" 'for 1,234.45 or -1,234.45
"#,##0.00_);(#,##0.00)" 'for 1,234.45 or (1,234.45)
"#,##0.00_);(#,##0.00);""-""_)" 'for 1,234.45 or (1,234.45) or - (for 0)

the format is positive;negative;zero;text

play around with the macro recorder to see differewnt styles.

 

[Gord Dibben]

Try this version.

=TEXT(Sheet2!A1,"#,##0.00")&CHAR(177)&TEXT(Sheet2!A2,"#,##0.00")

Because you have turned the numbers into Text you have lost the 2 DP formatting
so must re-create it in the formula.


Gord