operations on entire column
 

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?

operations on entire column
 

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.

operations on entire column
 

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

"SkipFlorida" wrote:

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?

operations on entire column
 

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 :-)
------------------------------*------------------------------*----------------



"SkipFlorida" wrote in message
...
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?