Macro to delete cell contents EXCEPT for last 5 characters

M

Monomeeth

Hi Everyone

I need a macro that can go down the cells of a column and delete the
contents of each cell EXCEPT FOR the last five characters. Each cell has
different content, and the length of the contents in the cells are different.

Below are some examples of cell contents:

/O=ATO/OU=WTCEXCH/CN=RECIPIENTS/CN=UBDDR
/O=ATO/OU=BXHEXCH/CN=RECIPIENTS/CN=UBA79
/O=ATO/OU=WTCEXCH/CN=USERS & WORKSTATIONS/CN=USERS/CN=UAWL5
/O=ATO/OU=WAYEXCH/CN=RECIPIENTS/CN=UA2SX
/O=ATO/OU=BRIEXCH/CN=USERS & WORKSTATIONS/CN=USERS/CN=UXC7C

Thanks for any help you can offer.

Joe.
 
P

paul.robinson

Hi
Quick enough without a macro?
1. If data in coulm A, starting at A1 then in B1 type = right(A1,5)
2. Copy the formula down thne copy that data and do Paste
Special...values only back onto column A.

regards
Paul
 

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

Extract all CN='Name' from a Active Directory data-dumped-cell 7
Find text in a cell and copy text to another cell 6
Find last row in workbook sheet & move data to it from another sh 5
Use ADO to add or update date in Access 10
Excel Macro - Speed increase suggestions needed. 2
Autofill until last cell in a row 1
New free joeware tool.... AdMod - sister to AdFind - Modify AD, Delete,Rename, Undelete 0
Help with Macro 3

Top