#1
|
|||
|
|||
Distributing letters from one cell to several
Hello!
I have created my own basic encrypting algorithm, similar to the Cesar cipher for instance. Now, I would like to have it digital, in Excel. The text that is to be encrypted, will be inputted in a single cell, and my question is: Is there a way to distribute/separate the characters, so that every one of them takes up no more than a single cell - to spread them out, so to speak. I.e. I need a formula for this. If this be possible, I would be eternally grateful... |
#2
|
|||
|
|||
=mid($a1,columns($a$1:a1),1)
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Distributing macros as buttons in the ribbon! | Ryhne | Word VBA | 1 | 04-27-2020 05:04 AM |
Wish to delete letters to the right of the cursor in a Table cell, but whole cell is being deleted | vjvj123 | Word VBA | 12 | 09-27-2018 03:09 PM |
Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow | FUGMAN | Excel Programming | 7 | 02-05-2017 08:37 AM |
Look up cell values with mixed number and letters | Cardinal2 | Excel | 1 | 02-10-2013 01:40 AM |
Importing and Distributing E-mail to Subfolders | martin1223 | Outlook | 1 | 08-25-2011 10:20 AM |