splitting cel contents

[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,

 

[Norman Harker]

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 b.]

Thanks!

 

[Van P.]

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