splitting cel contents

  • Thread starter Thread starter danny b.
  • Start date Start date
D

danny b.

Hi,
I am looking for a function that is able to do the following. I want the content of a cell to be split into pieces, eg. "house" is a string in a particular cell, i need "h" in seperate cell, "o" in another, etc.
Thanks in advance,
 
Hi Danny!

Try:

Data > Text to Columns
Use fixed delimiters applied to each character.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Danny

If the word "house" or any other word is in cell A1, try this formula =MID($A$1,COLUMN(A1),1) and copy it across cells B1 thru Z1. It will place each letter of a word in an individual cell

HT

Van P

----- danny b. wrote: ----

Hi
I am looking for a function that is able to do the following. I want the content of a cell to be split into pieces, eg. "house" is a string in a particular cell, i need "h" in seperate cell, "o" in another, etc
Thanks in advance
 
Back
Top