| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
Use Find and Replace
Find "CN=" (no quotes) Replace with "" (no quotes) -(absolutely nothing - dont even touch the field) This will leave you with just the name whatever it is. Try the first couple to ensure proper result then "all" -- Don C "TheLazer" wrote: I have a long list of cells that all contain the text 'CN=User Name'. I would like to remove all the text to the left of User Name leaving me with just that. Is there a function that can do this for me and if not could I and how would I go about doing it in VBA? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I create a formula from text in several cells? | Excel Worksheet Functions | |||
| How to create specific formula | Excel Worksheet Functions | |||
| How to create a text scrolling window? | New Users to Excel | |||
| Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) | |||
| match cell text with text in formula | Excel Worksheet Functions | |||
Threaded Mode
