Microsoft Office Forums - View Single Post - [Solved] Find/Replace Brackets Problem

Thread: [Solved] Find/Replace Brackets Problem

View Single Post

Old

08-04-2011, 11:05 AM

Kimberly

Kimberly is offline

Kimberly uses Windows 7 64bit

Windows 7 64bit Kimberly uses Office 2010 64bit

Kimberly uses Office 2010 64bit

Office 2010 64bit

Expert

Join Date: May 2010

Posts: 517

Kimberly is on a distinguished road

Default

you could use a formula...
=IF(OR(RIGHT(A1,1)=")",RIGHT(A1,1)="]"),TRIM(LEFT(A1,LEN(A1)-7)),A1)

Then do a copy and paste values.

Reply With Quote