how to convert numbers from different numbers of digits into only 2 digit ?

[Mareah]

Hi

I have one column with 2600 rows.
each cell have different numbers of digits.
How can I convert all number into only 2 digit using the first 2 digits?

e.g. I have 21100, 4643, 791 etc
and I want to convert the into : 21, 46, 79

 

[nocky]

Lets assume your data starts at cell A1, in cell B1 place the following formula =LEFT(A1,2).

Copy the formula down column B to the last row containing your data.

Cheers,

Chris (aka Nocky)

 

[Mareah]

WOOOOOOOW
I cannot thank you enough you save my time

That's REALLY AMAZING.

Thanks a million

 

[nocky]

You're welcome