Need a forumla help

I

Igneshwara reddy

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.
 
D

Don Guillett

Sub addchar()
For Each c In Range("h2:h4")
c.Value = "%" & c
c.Value = c & "%"
Next c
End Sub
 
D

Don Guillett

or
Sub addchar()
For Each c In Range("h2:h4")
c.Value = "%" & c & "%"
Next c
End Sub
 
Top