text string to character array

[RuthandAndy]

I need to check the first character of a text string to sort the text into different columns. Is there a way in VBA to look at just one character?

 

[Richard Schollar]

Hi

Dim aString As String

aString = "I am a string"

'extract first character:

Msgbox "First character is " & Left(aString,1)

 

[RuthandAndy]

Thank you.