Want to put text in "()" from column A to Column B

J

jennifer72401

I have a huge list of accronyms and then the spelled out version in column A,
i.e.: Lead (pb). I want the "(pb)" to be removed from column A and put into
column B. I bascially need the accronym in a separate column for all of my
entries. Is there an easy way to do this?

Thanks
 
N

Naz

Hi

Assuming your first entry, lead (pb) is in cell A1

Use the following to extract the name in B1
=LEFT(A1,FIND("(",A1)-2) result = lead

Use to extract the acronym in C1
=MID(A1,FIND("(",A1),10) result = (pb)

so your result will be

A B C
1 Lead (PB) Lead (pb)

Use as necessary, HTH :)
 
E

Elkar

Try this, assuming the tilde ~ character does not appear in any of your data
(if so, choose a different symbol that does not appear):

Do a Find/Replace on your data (column A)
Find What: (
Replace With: ~(
Then, select Column A
From the Data Menu, select "Text to Columns"
Select Data Type "Delimited"
Click NEXT
Uncheck all dellimiters except "Other"
Enter: ~
Click FINISH

That should do it.

HTH,
Elkar
 
Top