View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
michaelxhermes michaelxhermes is offline
external usenet poster
 
Posts: 1
Default Extract all letters from a cell sentence

Extract all letters from a text word or sentence

I would like to extract all the letters from a sentence which is entered in a
cell. I need each of the letters separately to encrypt them, I can then
can concatenate them back to form the encrypted sentence. (for a school
lesson on encryption)

I know I can use MID() function to extract each letter

But for this I need to have the position of the letter I want in the
function =MID(A1,start,1) but start increases by one for each letter, so
I need to hard code the start from 1 to say 50 to extract each letter in
turn

Is there any other way I can do this? So I dont have to hard code and so I
can have this extract working for any length of initial sentence!

I know I could do this is VB code but was just wondering if anyone knows a
simpler solution using the normal excel functions?

Thanks for your help

Michael