![]() |
|
#2
|
|||
|
|||
|
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. |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Find and Replace
|
kjxavier | Word | 6 | 08-19-2011 09:56 PM |
Find and Replace
|
kjxavier | Word | 9 | 08-11-2011 04:47 AM |
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 |