LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to copy the first word or two words from a cell containing a complete sentence to another cell jonny Excel Discussion (Misc queries) 7 May 19th 23 03:43 AM
Extract two letters bm Excel Discussion (Misc queries) 21 August 11th 07 05:56 PM
Extract letters from a cell Lupe Excel Worksheet Functions 2 November 22nd 06 06:33 PM
Extract bold letters in a cell hbamse Excel Worksheet Functions 1 March 21st 06 08:35 AM
Extract bold letters in a cell Stefi Excel Worksheet Functions 0 March 20th 06 02:51 PM


All times are GMT +1. The time now is 03:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"