insert a symbol into a function cell
 

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!

insert a symbol into a function cell
 

Try using this =text(sheet2!a1,"general")&"+"&text(sheet2!a2,"gen eral")
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Krista F" wrote:

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!

insert a symbol into a function cell
 

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?


"Martin Fishlock" wrote:

Try using this =text(sheet2!a1,"general")&"+"&text(sheet2!a2,"gen eral")
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Krista F" wrote:

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!

insert a symbol into a function cell
 

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

or

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


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


"Krista F" wrote:

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?


"Martin Fishlock" wrote:

Try using this =text(sheet2!a1,"general")&"+"&text(sheet2!a2,"gen eral")
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Krista F" wrote:

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!

insert a symbol into a function cell
 

Krista

Add it to the formula.

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


Gord Dibben MS Excel MVP

On Wed, 7 Mar 2007 15:41:13 -0800, Krista F
wrote:

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?


"Martin Fishlock" wrote:

Try using this =text(sheet2!a1,"general")&"+"&text(sheet2!a2,"gen eral")
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Krista F" wrote:

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!

insert a symbol into a function cell
 

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

Thanks for your help! Much appreciated.

"Martin Fishlock" wrote:

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

or

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


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


"Krista F" wrote:

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?


"Martin Fishlock" wrote:

Try using this =text(sheet2!a1,"general")&"+"&text(sheet2!a2,"gen eral")
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Krista F" wrote:

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!

insert a symbol into a function cell
 

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
on both sheets are specified as number, 2 decimal places...




"Gord Dibben" wrote:

Krista

Add it to the formula.

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


Gord Dibben MS Excel MVP

On Wed, 7 Mar 2007 15:41:13 -0800, Krista F
wrote:

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?


"Martin Fishlock" wrote:

Try using this =text(sheet2!a1,"general")&"+"&text(sheet2!a2,"gen eral")
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Krista F" wrote:

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!

insert a symbol into a function cell
 

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.



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


"Krista F" wrote:

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
on both sheets are specified as number, 2 decimal places...




"Gord Dibben" wrote:

Krista

Add it to the formula.

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


Gord Dibben MS Excel MVP

On Wed, 7 Mar 2007 15:41:13 -0800, Krista F
wrote:

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?


"Martin Fishlock" wrote:

Try using this =text(sheet2!a1,"general")&"+"&text(sheet2!a2,"gen eral")
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Krista F" wrote:

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!

insert a symbol into a function cell
 

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

On Wed, 7 Mar 2007 16:37:40 -0800, Krista F
wrote:

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
on both sheets are specified as number, 2 decimal places...




"Gord Dibben" wrote:

Krista

Add it to the formula.

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


Gord Dibben MS Excel MVP

On Wed, 7 Mar 2007 15:41:13 -0800, Krista F
wrote:

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?


"Martin Fishlock" wrote:

Try using this =text(sheet2!a1,"general")&"+"&text(sheet2!a2,"gen eral")
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Krista F" wrote:

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!