| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I remove spaces at the beginning of cells? | Excel Discussion (Misc queries) | |||
| Remove space at beginning of each name | Excel Discussion (Misc queries) | |||
| Remove Spaces beginning Time entry | Excel Discussion (Misc queries) | |||
| How do I remove a blanck space from the beginning of a formula? | Excel Worksheet Functions | |||
| Remove ' at beginning of cell | Excel Programming | |||
Linear Mode
