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

Visible Data
 

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"
osoft.com wrote in
message ...
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

Visible Data
 

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

"T. Valko" wrote in message
...
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"
osoft.com wrote in
message ...
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

Visible Data
 

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

--
Biff
Microsoft Excel MVP


"Wondering" wrote in message
et...
Why 255? The amount of data should be based on the length of the data in
the cell.

"T. Valko" wrote in message
...
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"
osoft.com wrote in
message ...
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

Visible Data
 

Thanks for your help. Works well

"T. Valko" wrote:

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"
osoft.com wrote in
message ...
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

Visible Data
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"I think I need to rephrase the question"
osoft.com wrote in
message ...
Thanks for your help. Works well

"T. Valko" wrote:

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"
osoft.com wrote in
message ...
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

Visible Data
 

Can the formula be modified to say that if the cell doesn't contain () then
it still displays the cells information

"T. Valko" wrote:

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"I think I need to rephrase the question"
osoft.com wrote in
message ...
Thanks for your help. Works well

"T. Valko" wrote:

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"
osoft.com wrote in
message ...
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