How do I count number of characters in a cell?

[TAngel]

Hi all,
I have a spreadsheet that has a string of numbers in cell C. I need to write a formula that counts the characters in cell C and if there are 12 characters bring over the left 11, if there are 11 characters bring over the left 10 else bring over the string. How do I do this?

Example of data

C D
334432976900 33443297690
556677850 556677850
39908711812 39908711812

Thank you in advance for your help.
Tee

 

[AnotherHiggins]

You are looking for the LEN function.

=Left(A1, Len(A1) - 1)

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[TAngel]

John, I need it to count how many characters are in the string before I do =Left(A1, Len(A1) - 1) (probably an if statement too?)

 

[TAngel]

Wait Wait Wait, I figured it out John.... I read what LEN does.

Thank you

 

[JPaules]

You could also use ASAP Utilities to tell you how many characters are in a cell.

--
JP

 

[AnotherHiggins]

No problem, TAngel. Happy to help.


JP - I've had ASAP Utilities installed for a few years and it seems like a really good tool (although I can't even tell you the last time I used it). But I don't see how it would help TAngel strip off the final character from each cell in a column.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.