How do I count how many characters before the space in a name under Microsoft Excel?

2 ⤊

Like for example: Alex James, I want excel to count how many characters were there before the space, in this case it's 5.

2007-08-07 09:52:31 · 5 answers · asked by jheks 2 in Computers & Internet ➔ Software

To be more precise, the Find function returns the starting position of one text string within another text string.

I give Walker13 a "Thumbs Up" !

2007-08-07 10:35:43 · answer #1 · answered by vbmica 7 · 0⤊ 0⤋

Count Characters In Excel

2016-12-08 14:38:39 · answer #2 · answered by ? 4 · 0⤊ 0⤋

Excel Count Characters

2016-10-01 02:55:54 · answer #3 · answered by ? 4 · 0⤊ 0⤋

Fantastic Online Market ===> http://shop1.4gw.pw/18pih

2016-05-20 04:47:31 · answer #4 · answered by Anonymous · 0⤊ 0⤋

This should work for the formula you want.

=FIND(" ",A2)

2007-08-07 09:59:54 · answer #5 · answered by Anonymous · 2⤊ 0⤋