need formula to set charakters

  • Thread starter Thread starter altrox2255
  • Start date Start date
A

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??
 
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??
Click to expand...

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
 
Back
Top