Strip Extra text

[miztiik]

i have a data like shown below

Cell - A1
abc(Sometext_or_number)
def(Sometext_or_number)
ghi(Sometext_or_number)
jkl(Sometext_or_number)
mno(Sometext_or_number)
pqr(Sometext_or_number)

When i run a macro i want only this part

abc
def
ghi
jkl
mno
pqr

There will always be an opening brace and an closing after the initial text.

Thanks in advance

 

[Stormseed]

Select the Data Range --> Excel menu --> Data - Text to Columns - Delimited - Check "Other" in Delimiters option in the window. Put "(" (without quotes) in the box. Click Finish.

You can also record a macro for these steps !

Repeat the same steps if you want to clean the data with a ")".

Select the Data Range and then put ")" (without quotes) in the box. Click Finish.

 

[ADAMC]

Does it have to be a macro:

Formula in B1 filled down:

=MID(A1,1,3)

 

[ravishankar]

Hi
the simplest would be B1= left(A1,3) and double click the autofill handle (Plus sign) on bottom right hand corner of the cell to fill till the end of data.
Paste the following codes in the macro window ( Alt F11)

x = cells(rows.count,1).end(xlUP).row
for a = 1 to x
b= cells(a,1)
cells(a,2) = left(b,3)
next a

if more than three characters can exist before the bracket then replace line 4 with
c= instr(b,"(")
cells(a,2) = left(b,c-1)
Ravi

 

[Peter_SSs]

Another non-macro possibility...

1. Select the column by clicking its heading label.
2. Edit | Replace... | Find what: (* | Repalce with: leave blank | Replace All