3 Comments

1. cozmosis says:

   June 29, 2008 at 10:43 pm

   Do you think repeating the question makes it more understandable? Do you think repeating the question makes it more understandable? You would have been better served to give more details.

   Try Data\Text to Columns

   Terse question = terse answer
2. VBAXLMan says:

   July 1, 2008 at 6:52 am

   cozmosis got a point but I think I know what you mean
   You probably want to create a list of cells to have a letter on each
   if this is what you want?
   Use this
   IF the cell with the word is B5
   then paste this in B6
   =mid($B$5, ROW()-5 ,1)

   copy and paste this into the cells below

   Yeah, I know I am good, I am the VBAXLMan and I am back
3. johncaulfield100 says:

   July 2, 2008 at 6:09 am

   Excellent function VBA man!. Just in case the questioner cannot figure out the columns option using the same references as you they could use

   =MID($B$5, COLUMN()-2,1) else copy and paste special range transpose your answer.