software

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?

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.You might try splitting the cells, setting it up to separate between the 2nd
and 3rd digit, then delete the unwanted column.

quot;SkipFloridaquot; wrote:

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

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 :-)
------------------------------*------------------------------*----------------
quot;SkipFloridaquot; gt; wrote in message
...
gt;I need to eliminate the first two of four digits for each entry in an
gt;entire
gt; column. Can this be done through a math or other manipulation?