Number Length

[Dohko]

Hi

Is there an easy way of determining the length of a column
like
A
4
4
4
66
77.44
88,000

I know if I use the Len function I'll get the result. However if the data has commas or periods it won't read them.
I would like to know if there is a function that would let me know that there are 5 characters in the cell that has 77.44.

Thanks

[VBA Noob]

Returning the correct len for me

What result are you getting

VBA Noob

[Dohko]

Did you get 5?
It only counts the numbers for me not everything.
for example 88,000 only returns 5
88.000 returns 6. that's working fine

[VBA Noob]

It works unless its a even number

e.g

66.00

VBA Noob

[Dohko]

that's fine. I really dont need that one.
But I was wondering if there is a way to fix
3,500
With the comma it doesnt work
unless its something like 44,00

[VBA Noob]

Try this

=IF(CELL("format", A1)="F2",LEN(A1)+3,LEN(A1))

VBA Noob

[Dohko]

it returns a 4. for 3,400

[VBA Noob]

Try

=IF(CELL("format",A1)="F2",LEN(A1)+3,IF(CELL("format",A1)=",0",LEN(A1)+1,IF(OR(CELL("format",A1)=",0",CELL("format",A1)="F2"),"",LEN(A1))))

VBA Noob