Macro to delete cell contents EXCEPT for last 5 characters
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!
|