How to count the total number of leading and trailing spaces in cells?

[Rnkhch]

Hello,

I'm trying to come up with a way to count leading and trailing spaces in cells. I have seen posts discussing ways of trimming such spaces, but I didn't see anything about counting them.

(The reason I need this is that it will help me identify the source software from which some of my data comes from. When students copy and paste data from the source, cells get pasted with leading and/or trailing spaces in addition to other source formatting etc.)

Thanks for any input!

P.S. By the way, by "total" in the title, I didn't mean the sum of leading and trailing space counts. I need them separately.

 

[BSALV]

=len(text)-len(trim(text))
sorry, didn't read the PS.

Map2
	A	B	C	D
1	abcde fghi	4	leading	22
2		8	trailing	10
3				12
Blad1

Cell Formulas
Range	Formula
B1	B1	=SEARCH(LEFT(TRIM(A1),1),A1,1)-1
B2	B2	=LEN(A1)-B1-LEN(TRIM(A1))
D1	D1	=LEN(A1)
D2	D2	=LEN(TRIM(A1))
D3	D3	=+D1-D2

 

[bebo021999]

With text string is in A2:
In B2:
=LEN(A2)-LEN(TRIM(A2))

 

[bebo021999]

Sorry for my misunderstanding in previous post.
If A2 could be:
"abc" => 0
" abc " => 1 + 1
" a bc " => 1 + 1 (not count space inside a & bc)

B2 (count leading spaces):
=MATCH(TRUE,INDEX(CODE(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1))<>32,),0)-1

C2 (count trailing spaces):
=LEN(A2)-AGGREGATE(14,6,ROW(INDIRECT("1:"&LEN(A2)))/(CODE(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1))<>32),1)

 

[Rnkhch]

Awesome! Thanks much for fast response guys!