Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: How do I get excel to work with text in the following way

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I want to enter text(sentences and paragraphs) into excel so that each CHARACTER of text has its own cell. Is there a way to do this so that when I type in the text, the cell box would automatically jump to the box to the right after I had entered a character. As of right now I have to hit a character then return, a charcter then return(very inconvenient)... Any ideas would be appreciated.

    Thank you in advance for your assistance

    Greg

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,584
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Greg

    You might like to try this:
    Type your sentence in A1 then enter this formula in A2 and scroll to the right

    =(MID($A$1,COLUMN(),1))

    This will split you sentence up into one character (or space) per cell.

    Hope this is of some help
    regards
    Derek

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I would like to adjust what you suggested in the following way: I'd like to type the sentence in A1 and then have each character in its own cell to the right of the sentence but in the SAME row instead of the row underneath. Your formula seems to work when I adjust it in this way EXCEPT it misses the very first charcter of each sentence. Any suggestions on how to fix this?

    THank you very much for your suggestion

    Sincerely
    Greg

  4. #4
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I think it's only a missing -1

    =MID($A$1,COLUMN()-1,1)


    _________________
    Kind Regards
    Dave Hawley
    OzGrid Business Applications
    Microsoft Excel/VBA Training


    [ This Message was edited by: Dave Hawley on 2002-03-22 08:14 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •