ExcelBanter - Masking character

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Masking character (https://www.excelbanter.com/excel-programming/309720-masking-character.html)

joe

Masking character

Hi,

How to mask off the character that i do not want and
retain certain characters? example

original: F1234j

change one: F1xxxj

where F,1 and j is retained.

many thanks.

regards,
Joe

Tom Ogilvy

Masking character

s = "F1234j"
s = left(s,2) & right(s,1)

--
Regards,
Tom Ogilvy

"Joe" wrote in message
...
Hi,

How to mask off the character that i do not want and
retain certain characters? example

original: F1234j

change one: F1xxxj

where F,1 and j is retained.

many thanks.

regards,
Joe

All times are GMT +1. The time now is 10:15 AM.