Truncate value of a cell

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

Guest

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
 
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
Click to expand...

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
 
Back
Top