Every character in cell

[akschary]

Dear all
Can any one tell is there any formula for each character in a cell or block
for example EXCEL [TABLE="width: 300"]
<tbody>[TR]
[TD]E[/TD]
[TD]X[/TD]
[TD]C[/TD]
[TD]E[/TD]
[TD]L[/TD]
[/TR]
</tbody>[/TABLE]

 

[Andrew Poulsom]

Formula in B1 copied across:

Excel 2010
	A	B	C	D	E	F
1	EXCEL	E	X	C	E	L
Sheet1

Cell Formulas
Range	Formula
B1	=MID($A1,COLUMNS($B1:B1),1)

 

[Special-K99]

What you've said makes little sense.

Try text to Columns with Fixed Width

 

[akschary]

Thank u very much
but i need in the same cell not in different cell