Hi,

The data is like this,

1abcde2
stuvwxyz
bcdef49853912

For every first and last character in a cell has to be replaced with %

Ex: for first cell the answer will be %abcde%

Let me know if any forumla will be helping me.

Appreciated your help in advance.