Remove last two characters in multiple cells

[Michael Martis]

Is there a way I can remove the last 2 digits of a field
from 14 characters to 12? There are over 2000 entries and
would prefer not to do it manually.

Please Advise

 

[Chip Pearson]

Try a formula like

=LEFT(A1,LEN(A1)-2)

Copy this formula down as far as you need to go, and then copy
the results, and Paste Special Values back over the original
data.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[RagDyeR]

You could use
<Data> <TextToColumns>
Click "Fixed Width", then <Next>,
Follow the directions, if necessary, to move the column break to the last
two digits,
Then <Next>,
Click in the column containing the last two digits, (turns black),
Check "Do Not import", then <Finish>

You should now have your original column, less the last 2 digits.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Is there a way I can remove the last 2 digits of a field
from 14 characters to 12? There are over 2000 entries and
would prefer not to do it manually.

Please Advise

 

[Soo Cheon Jheong]

Michael,

=IF(LEN(A1)>2,REPLACE(A1,LEN(A1)-1,2,),"")