remove beginning of data
 

I have one big excel spread sheet like this:
90007569,02:D114-
90007569,03:D115-
90007569,04:D116-
90007569,05:D117-
90007569,06:D041-
90007569,07:F1109-

I need to be removed from the left "90007569, D2:" and last right "-", all
I need it is D114, D115, D116 all the way done, how to write the macro for
this?

Thanks.

Lillian

remove beginning of data
 

You can do it with a simple formula. If your data starts at cell A1,
enter the following in cell B1:

= MID ( A1, 14, LEN (A1) - 14)

Copy this down the column, then use Copy | Edit | Paste Special |
Values | OK and press enter to fix the values. Then you can delete
column A.

Pete

remove beginning of data
 

If data is in A1 then:

=MID(A1,14,LEN(A1)-14) should do it
--
Gary''s Student


"Lillian" wrote:

I have one big excel spread sheet like this:
90007569,02:D114-
90007569,03:D115-
90007569,04:D116-
90007569,05:D117-
90007569,06:D041-
90007569,07:F1109-

I need to be removed from the left "90007569, D2:" and last right "-", all
I need it is D114, D115, D116 all the way done, how to write the macro for
this?

Thanks.

Lillian