Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-04-2021, 08:59 AM
Ladybird Ladybird is offline Distributing letters from one cell to several Windows 10 Distributing letters from one cell to several Office 2019
Novice
Distributing letters from one cell to several
 
Join Date: Jul 2021
Posts: 1
Ladybird is on a distinguished road
Exclamation 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...
Reply With Quote
  #2  
Old 07-04-2021, 09:19 AM
Purfleet Purfleet is offline Distributing letters from one cell to several Windows 10 Distributing letters from one cell to several Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

=mid($a1,columns($a$1:a1),1)
Reply With Quote
Reply

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
Distributing letters from one cell to several 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
Distributing letters from one cell to several 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:10 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft