How to remove specific character from specific shell

[ramki]

Hi,

For Example

Column A
235024
631454
325412
631421
324125
624144
631441

I Want first three characters from the left and to remove rest of the charactes from each cell.

I need the output like this

Column A
235
631
325
631
324
624

Please help with the formula to get this output. Please Help


Thanks in Advance

[mrice]

Type

=LEFT(A1,3)

into B1 and copy down.

Alternatively use Data - Text to Columns and select the fixed width option.

[ramki]

Thanks mrice for instant reply. You and this forum is awesome................