Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 08-04-2011, 11:05 AM
Kimberly Kimberly is offline Find/Replace Brackets Problem Windows 7 64bit Find/Replace Brackets Problem 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
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find/Replace Brackets Problem Find and Replace kjxavier Word 6 08-19-2011 09:56 PM
Find/Replace Brackets Problem Find and Replace kjxavier Word 9 08-11-2011 04:47 AM
Find/Replace Brackets Problem Help with find and replace or query and replace shabbaranks Excel 4 03-19-2011 08:38 AM
find and replace anil3b2 Word 0 08-03-2010 11:30 PM
Find /Replace Help ilcaa Word 2 11-02-2009 08:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:35 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft