Need a forumla help

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

 

[JE McGimpsey]

One way:

="%" & MID(A1,2,LEN(A1)-2) & "%"

 

[Don Guillett]

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

 

[Don Guillett]

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