View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
external usenet poster
 
Posts: 622
Default text substitution

So, you have 2 cells in the same line showing the same info so you can
always see one since they are far apart? Is that correct?

Why not just choose one to always be the one with the location typed
in. The other one is just "=A1", or whatever cell reference you need.