Trim

[weitomtom]

HI Master.

I am wondering how to trim a row and remove part of a cell's information

My two queries below.

Query 1

Before After

Customer Customer
ABCD (1234) ABCD
AAAAAAA (321) AAAAAAA

xxxxxxxxxxxxxxxxxxxxxxxx

Query 2

Before After

Customer Customer
ABCD (1234) 1234
AAAAAAA (321) 321

Thanks in advance.
Tom

 

[weitomtom]

Query 1

Before

Customer
ABCD (1234)
AAAAAAA (321)

After
Customer
ABCD
AAAAAAA


Query 2

Before

Customer
ABCD (1234)
AAAAAAA (321)

After
Customer
1234
321

 

[RasGhul]

Try

Query 1
=LEFT(A1,SEARCH(" ",A1)-1)

Query 2
=SUBSTITUTE(RIGHT(A4,LEN(A4)-SEARCH("(",A4)),")","")