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!

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

On Feb 11, 5:54*am, Monomeeth
wrote:
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!