need formula to set charakters

[altrox2255]

Hallo i need formula to set characters for example:

word: HOME.

i need set last letter to another something like a table in C++

home[4]

h = [0]
o = [1]
m = [2]
e = [3]

set [3] to latter E

i know its hard to understand but if someone does, please tell me it is possible in exel??

 

[Norman Jones]

Hallo i need formula to set characters for example:



word: HOME.



i need set last letter to another something like a table in C++



home[4]



h = [0]

o = [1]

m = [2]

e = [3]



set [3] to latter E



i know its hard to understand but if someone does, please tell me it is possible in exel??

Hi Altro,

I may well have misunderstood your requirement, but perhaps try something like:

'==========>>
Option Explicit

'---------->>
Public Sub aTester()
Dim arr() As Variant
Dim i As Long, j As Long
Const sStr As String = "Home"
Const aCharacter As String = "E"

i = Len(sStr)
ReDim arr(1 To i)
For j = 1 To i
arr(j) = Mid(sStr, j, 1)
Next j


arr(4) = aCharacter

End Sub
'<<==========


===
Regards,
Norman