Visible Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Maybe something like this.

Assuming there is always a set of ( ) in the referenced cell.

=LEFT(A1,FIND("(",A1)-2)&MID(A1,FIND(")",A1)+1,255)

--
Biff
Microsoft Excel MVP


"I think I need to rephrase the question"
 
255 is an arbitrary large number that pretty much guarantees all the
remaining text will be returned.
 
Thanks for your help. Works well

T. Valko said:
Maybe something like this.

Assuming there is always a set of ( ) in the referenced cell.

=LEFT(A1,FIND("(",A1)-2)&MID(A1,FIND(")",A1)+1,255)

--
Biff
Microsoft Excel MVP


"I think I need to rephrase the question"
Click to expand...
 
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"I think I need to rephrase the question"
 
Can the formula be modified to say that if the cell doesn't contain () then
it still displays the cells information
 
Back
Top