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

Macro to Run Functions and VBA code??? 0
Extract all CN='Name' from a Active Directory data-dumped-cell 7
Find text in a cell and copy text to another cell 6
Replies to calender meeting invitations result in a NDR 0
Find last row in workbook sheet & move data to it from another sh 5
Unable to delete permissions for deleted user account 0
Automatically Combine Cell Contents and Delete Rows 0
Use ADO to add or update date in Access 10

Top