Quick moves

[Robbert82]

Hello,

I have a colum with a lot of data, that loos like this:
10.000V
11.000V
23.000V
ext.

With every data the V (voltage) must I delete, this is a lot of work, is there a quick way to do the same??
Thank you,

Robbert

 

[BrianB]

Copy this formula down a new column :-
=LEFT(A1,LEN(A1)-1)

 

[Robbert82]

Thank you

Thank you!!!

It is working

Greetz Robbert