| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
consider your text lies in cell A1, then use the following formula:
=RIGHT(A1,LEN(A1)-FIND("=",A1)) - Mangesh "TheLazer" wrote in message ... 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
