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.

One way:

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


In article ,
Igneshwara reddy wrote:

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.

Sub addchar()
For Each c In Range("h2:h4")
c.Value = "%" & c
c.Value = c & "%"
Next c
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Igneshwara reddy" wrote in
message ...
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.

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Igneshwara reddy" wrote in
message ...
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.