View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
daj daj is offline
external usenet poster
 
Posts: 2
Default Sorting cells with Combined Text and Numbers

I have a document that has a column that combines various text and numbers
from within the sheet (using a formula, such as =A12"& plus "&A13).

Every time I sort the column w/ combined text/numbers is reference using an
absolute refernce. Is there a way to sort the sheet w/ relative referencing.

Thanks,
daj