Hi,

I have a cell which contains text and numeric. Example is abcd1970

I need to create a formula or VBA ( which I am not familiar) that could change the entire text numeric to a new one based on the following criteria:

1) Total characters should be at least 8
2) Should be text and numeric
3) No single characters should be repeated.

The formula should populate a new information in the cell upon prompted by a key or macro button as this needs to be generated repeatedly.

Example- Current info =abcd1970
New Info =efgh2345

Is this possible ?

Thanks in advance.