Hey everyone, I am trying to take a string of text and have each character in the string separated to different cells.
For instance: on Sheet 1 / Cell B10 I have the word "MONROE". I want that word broken down and on Sheet 2 / Cell B1 have the "M", Cell B2 "O", Cell B3 "N", so on and so forth.
I am a Police Officer, and this is for a Crash Report. Any help would be greatly appreciated.
Last edited by MattVarnell; 01-17-2011 at 11:44 PM.
tRY:
=MID(Sheet1!$B$10,ROWS($A$1:$A1),1)
copied down
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thanks! That worked, however is there a way to do it copied from Left to Right?
With
=MID(Sheet1!$B$10,COLUMNS($A$1:A$1),1)
EUREKA! Thank you very much!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks