Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to copy the first word or two words from a cell containing a complete sentence to another cell | Excel Discussion (Misc queries) | |||
Extract two letters | Excel Discussion (Misc queries) | |||
Extract letters from a cell | Excel Worksheet Functions | |||
Extract bold letters in a cell | Excel Worksheet Functions | |||
Extract bold letters in a cell | Excel Worksheet Functions |