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.
--
If you can measure it, you can improve it!