Remove last two characters in multiple cells

  • Thread starter Thread starter Michael Martis
  • Start date Start date
M

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
 
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
 
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
 
Back
Top