 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / March 2007insert 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! Try using this =text(sheet2!a1,"general")&"+"&text(sheet2!a2,"general")  SignatureHope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. > 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 [quoted text clipped - 3 lines] > For clarity, I am trying to merge a mean and sd from two separate columns... > Using Excel 07 - Any suggestions would be super! 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? > Try using this =text(sheet2!a1,"general")&"+"&text(sheet2!a2,"general") > [quoted text clipped - 5 lines] > > For clarity, I am trying to merge a mean and sd from two separate columns... > > Using Excel 07 - Any suggestions would be super! 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. > Thanks Martin, > [quoted text clipped - 11 lines] > > > For clarity, I am trying to merge a mean and sd from two separate columns... > > > Using Excel 07 - Any suggestions would be super! It works using the & CHAR() function! Although it automatically increases the values to 8 decimal places... Thanks for your help! Much appreciated. > Try: > ="±"&TEXT(Sheet2!A1,"general")&"±"&TEXT(Sheet2!A2,"general") [quoted text clipped - 23 lines] > > > > For clarity, I am trying to merge a mean and sd from two separate columns... > > > > Using Excel 07 - Any suggestions would be super! Krista Add it to the formula. =text(sheet2!a1,"general")&CHAR(177)&text(sheet2!a2,"general") Gord Dibben MS Excel MVP >Thanks Martin, > [quoted text clipped - 11 lines] >> > For clarity, I am trying to merge a mean and sd from two separate columns... >> > Using Excel 07 - Any suggestions would be super! 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... > Krista > [quoted text clipped - 19 lines] > >> > For clarity, I am trying to merge a mean and sd from two separate columns... > >> > Using Excel 07 - Any suggestions would be super! 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. SignatureHope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. > 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 [quoted text clipped - 23 lines] > > >> > For clarity, I am trying to merge a mean and sd from two separate columns... > > >> > Using Excel 07 - Any suggestions would be super! 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 >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 [quoted text clipped - 23 lines] >> >> > For clarity, I am trying to merge a mean and sd from two separate columns... >> >> > Using Excel 07 - Any suggestions would be super! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.