| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print Visible Data Only | Excel Discussion (Misc queries) | |||
| Print Visible Data Only | Excel Worksheet Functions | |||
| print visible data only | Excel Worksheet Functions | |||
| how do I sum only visible data in a column | Excel Discussion (Misc queries) | |||
| Autoshapes not visible on spreadsheet but visible in print preview | Excel Discussion (Misc queries) | |||
Linear Mode
