hi

any help with this appreciated,

Data text in worksheet i need it replaced with abbreviation always the same text that i need replaced not always in same cell tho i need it replaced with a macro so i can add it to other macros in vba..to make it easier for end user.


at Beit bridge border postneed it replaced with say BBBP and in another cell , 12 kms from chirundu Border post with say CBPhope this makes sense.


thanks