Removing Letters with brackets from inside a cell

[Pauls123]

Hi all,

A little while since I been here. My question is after copying and pasting data from a website to Excel 2010, I am left with say"

Paul (NZ) or say Paul (IRE), for example.

I just want Paul shown and not the brackets or letters contained therein.

Regards, Paul

 

[VoG]

Try

=LEFT(A1,FIND("(",A1)-2)

 

[Pauls123]

Thanks VoG, That seems to work except there could be other cells under it, where there are no brackets. Will this work if there isnt any brackets,

Regards
Paul

 

[Biz]

Try

Method 1
=IF(ISERROR(LEFT(A1,FIND("(",A1)-2)),A1,LEFT(A1,FIND("(",A1)-2))

Method 2
=IF(ISERROR(LEFT(A2,FIND("(",A2)-2)),"",LEFT(A2,FIND("(",A2)-2))

Which method answers your question?

Biz

 

[Pauls123]

it doesnt seem to work if there are no brackets after names. Sometimes in my spreadsheet, some cells will have brackets (with letters in them), others wont,

Regards
Paul

 

[Biz]

it doesnt seem to work if there are no brackets after names. Sometimes in my spreadsheet, some cells will have brackets (with letters in them), others wont,

Regards
Paul

Give some examples.

 

[Pauls123]

Hi Biz, Your reply come in exactly the same time as I typed my other post. Your Method 1 works perfectly, thanks very much.

Regards

Paul

 

[Sektor]

UDF

Function ExtractStr(str As String) As String
    With CreateObject("VBScript.RegExp")
        .Pattern = "\w+(?!\))"
        ExtractStr = .Execute(str)(0)
    End With
End Function

 

[Biz]

Hi Biz, Your reply come in exactly the same time as I typed my other post. Your Method 1 works perfectly, thanks very much.

Regards

Paul

Thanks for your feedback

Biz

 

[Biz]

UDF

Function ExtractStr(str As String) As String
    With CreateObject("VBScript.RegExp")
        .Pattern = "\w+(?!\))"
        ExtractStr = .Execute(str)(0)
    End With
End Function

Nice RegExp mate.

Biz