Truncate value of a cell
 

Hi,

I am looking for a way to truncate information in parenthesis in a cell.
Everything that is to the right of the first parenthesis should be removed.

Any ideas ?

Nde

Truncate value of a cell
 

On Jun 27, 4:02 pm, Nde wrote:
Hi,

I am looking for a way to truncate information in parenthesis in a cell.
Everything that is to the right of the first parenthesis should be removed.

Any ideas ?

Nde

In A1, put this value: ="Test(1,2,3)"
In A2, put this formula: =MID(A1,1,SEARCH("(",A1))

Now A2 contains "Test("

If you are trying to actually lose the hidden content, you'll need to
copy cell A2 and paste-special it back as "Values" and then delete the
contents of A1.
I think this is the concept you need.

Brian Herbert Withun