Macro to delete cell contents EXCEPT for last 5 characters

  • Thread starter Thread starter Monomeeth
  • Start date Start date
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.
 
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
 
Back
Top