Thread: Visible Data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
I think I need to rephrase the question I think I need to rephrase the question is offline
external usenet poster
 
Posts: 20
Default Visible Data

Is the following possible?

When I type data into a cell, I would like anything that is typed in
brackets () to be excluded when referenced by another cell. The data in the
original cell would be variable.

ie A1 = I would like (to exclude the data in brackets) when referenced in
cell A2
A2 = I would like when referenced in cell A2