Replacing a Certain Character (resolved)

[macai]

Hello. I want to replace a very specific character with another
character, going by the number. This meaning, i want to replace
characters by which character they are.

Lets take the string "abcdefghijklmnopqrstuvwxyz". I want to be
able to take, say the fifth character in it ("e") and replace it with
some other character (lets say "c"), how could i accomplish this?

[brenaaro]

sNewString = Replace("abcdefghijklmnopqrstuvwxyz","e","c")

[macai]

THat will replace every single copy of "e" with "c". I want that
SPECIFIC copy of "e" to be replace with "c". Get where im at?

[Shawn N]

Use the Mid and InStr functions.

[macai]

Public Function RpChr(Expression As String, ChrNm As Long, ChrRp As String)
 RpChr = Left(Expression, ChrNm - 1) & Replace(Expression, Mid$(Expression, ChrNm, 1), ChrRp, ChrNm, 1)
End Function

RpChr Function
Parameters
Expression
A string containing the data which will be replaced.
ChrNm
The character number that will be replaced.
ChrRp
The character which ChrNm will be replaced with.

Example

x = RpChr("abcdefghijklmnopqrstuvwxyz", 5, "c")

This will return "abcdcfghijklnmopqrstuvwxyz".