|
|
#3
02-21-2018, 09:34 AM
|
|||
|
|||
Column A will always only have one right parenthesis and one left, and the content between will always be a six-character system ID. For example, my name is Kevin T Bradley and my system ID is ktbradl, so several cells in Column A will be populated with the following:
Bradley, Kevin T (KTBRADL) I only need the first and last name to appear. I can live with the middle initial, so if it's easier to just remove the parentheses and the content between them that would be fine. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to remove first 12 characters of each cell | King Mustard | Excel | 3 | 04-07-2017 12:06 AM |
| Can I remove spaces between only Chinese characters? | sivartnosredna7 | Word | 2 | 01-09-2017 05:33 AM |
 How do I Remove A Specific Amount of Characters from Lines in a Document?
|
tatihulot | Word | 5 | 01-22-2016 05:55 AM |
| Find and Replace Parenthesis with Itallics | Richard Carr | Word | 1 | 01-06-2015 06:44 PM |
| How to remove these unknown characters appearing | rajpes | Word | 1 | 03-02-2012 03:24 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode