Hi all,
I'm trying to find/create a function to extract the nth character in a string of characters.
For instance, in A1 I have the text:
"wheninthecourseofhumaneventsitbecomesnecessaryforonepeopletodissolvethepoliticalbandswhichhaveconnectedthemwithanotherandtoassumeamongthepowersoftheearththeseparateandequalstationtowhichthelawsofnatureandofnaturesgodsentitlethemadecentrespecttotheopinionsofmankindrequiresthattheyshoulddeclarethecauseswhichimpelthemtotheseparation"
I'm trying to extract the characters 33, 36, 38, 25, etc.
Any idea ?
Please note that I can't use VB so it would have to be an excel formula (if possible) !
Bookmarks