Create a formula to remove text to the left of specified char?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
consider your text lies in cell A1, then use the following formula:

=RIGHT(A1,LEN(A1)-FIND("=",A1))


- Mangesh
 
Another way..........if your list is in column A, put this in B1 and copy
down.........

=MID(A1,FIND("=",A1,1)+1,99)

Vaya con Dios,
Chuck, CABGx3
 
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"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to remove stuff that appears when I click on the windows button on the bottom left of my screen? 2
Searching the formula (not the value) for a text string 1
Reference text in a cell inside a formula to specify a sheet name 4
FIND from right to left instead of left to right 8
Removing part(s) of text from downloaded data 14
Remove Text 7
Text to the left and right of a character 4
Delete rows based on contents of Col A 0

Back
Top