Visible Data

  • Thread starter I think I need to rephrase the question
  • Start date
I

I think I need to rephrase the question

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
 
T

T. Valko

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"
 
W

Wondering

Why 255? The amount of data should be based on the length of the data in the
cell.
 
T

T. Valko

255 is an arbitrary large number that pretty much guarantees all the
remaining text will be returned.
 
I

I think I need to rephrase the question

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...
 
T

T. Valko

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"I think I need to rephrase the question"
 
I

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
 
Top