Reveal number of characters in prior column

[rebel123]

Looking for equation with equals sign for the correct answer.
The correct answers are in green.

Looking for an equation that shows the number of characters in the prior column.
I tried =CHAR and selected the cell from the previous column and that did nothing.

 

[etaf]

Perhaps Len() will give you the lenght of items in the cell But not just characters will include any spaces or numbers

Book2
	A	B
1	abc	3
2	abcde	5
3	mc	2
4	aa	2
5	a	1
6	123	3
7	12 45	5
8	1245	4
Sheet1

Cell Formulas
Range	Formula
B1:B8	B1	=LEN(A1)

 

[rebel123]

Thanks worked gr8

 

[etaf]

you are welcome, edited my post to show an XL2BB example