Hi Dave

Try
=IF(ISERROR(FIND("(",A1)),A1,LEFT(A1,FIND("(",A1)-2)&MID(A1,FIND("(",A1),255))


--
Regards

Roger Govier


"Dave" wrote in message
...
Hi Roger
Thanks for your help.
Your formula worked perfectly with all the names with (---) brackets but
those without brackets showed "#VALUE!" i'm sorry about that I should have
mentioned that.
Is there a way around this.
Any further help with this problem would be appreciated.
regards
Dave

"Roger Govier" wrote:

Hi Dave

Try
=LEFT(A1,FIND("(",A1)-2)&MID(A1,FIND("(",A1),255)

--
Regards

Roger Govier


"Dave" wrote in message
...
How can I trim the last space from text but leave the other spaces
intact
ie:- Red Lancer (IRE) Red Lancer(IRE)
Torrent (IRE) Torrent(IRE)

Sir Edward Landseer (FR) Sir Edward Landseer (FR)

I've tried =SUBSTITUTE(A1," ","") but this trims all the spaces out.
Any help will be welcomed.