View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tralst tralst is offline
external usenet poster
 
Posts: 4
Default Expanding Formulas

I know that I can show the work in a formula by simply using a &. Example,
with A1 =2 and A2 =3, I type =A1+A2 in a cell This can be converted to the
cells values by entering =A1&"+"&A2. This will return 2+3 in the cell. My
question. Is there a shortcut to accomplish this?