How to separate letters in different cells

[Luiz Tacchi]

I have a cell with the letters "a b c" and I have to have each letter in separate cells. Please, how to do it?

 

[Gerald Higgins]

Hi, welcome to the board.

There is more than one way to do this. One very quick way is to use the Data, Text to Columns function, specifying the space character as the delimiter.

 

[Luiz Tacchi]

I am not expert in Excel. Could you give me an example? Thanks

 

[Gerald Higgins]

Using Excel 2003 . . .

select your data
From the top menu, select Data
Select Text to Columns
play around with the options . . .

 

[Luiz Tacchi]

I solved my problem using the fx "EXT.TEXT" and "NUM.CARACT". Thanks.