Data Security - Replacing first four digits of a membership number macro.

Hi again all,

Is there a bit of magic code that can change the first four digits of a membership number to x's? for example 123456789 would become xxxx56789. it needs to be applied to a whole column each and every day.

Also, While I'm here...I need to delete all rows that contain a date (in the date column) prior to 22/09/08. Any idea's? Thank you very much.

Matt

Hi there:

I think the formula you'd be looking for is =SUBSTITUTE(A2,LEFT(A2,4),"xxxx",1)

For the second part, you could apply an autofilter (Data, Filter, Autofilter) and, from the drop down in the Date column, select Custom, Date is or less than 22/09/08 and delete those rows.