operations on entire column

S

SkipFlorida

I need to eliminate the first two of four digits for each entry in an entire
column. Can this be done through a math or other manipulation?
 
D

Dave O

Assuming your data is in column A, you can insert a column (or use a
blank column) and enter this formula:
=MID(A1,3,2)
Then copy and paste that formula down so it considers the remaining
cells in the column. The formula assumes that each entry has only 4
characters.
 
S

ShaunR1967

You might try splitting the cells, setting it up to separate between the 2nd
and 3rd digit, then delete the unwanted column.
 
K

Ken Wright

Every cell is 4 characters right?

Select Column, do Data / text to columns / fixed width / insert break after
2nd character, hit next, click on first column and choose 'do not import
column'.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
Top