| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting certain numbers of characters in a cell in a column
I have a column of data that is a document number and business name:
L06000037660CENTRAL FLORIDA HORSE BEDDING, LLC P06000051712FERRO TRUCKING INC Each company has a 12 digit document number right next to the business name, and I would like to delete the document number from an entire column. Does anyone know of a macro that could accomplish this? Thanks ahead of time, Erik |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
deleting certain numbers of characters in a cell in a column
Use this formula and copy down in spare column. Change A1 to start row/column
=RIGHT(A1,LEN(A1)-12) HTH "Erik" wrote: I have a column of data that is a document number and business name: L06000037660CENTRAL FLORIDA HORSE BEDDING, LLC P06000051712FERRO TRUCKING INC Each company has a 12 digit document number right next to the business name, and I would like to delete the document number from an entire column. Does anyone know of a macro that could accomplish this? Thanks ahead of time, Erik |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting characters that are not numbers | Excel Discussion (Misc queries) | |||
| Deleting Blank Characters in a Cell | Excel Discussion (Misc queries) | |||
| Deleting unneeded characters in a cell | Excel Programming | |||
| deleting the last nine characters in a cell | Excel Programming | |||
| Deleting unwated control characters at the end in a particular column | Excel Programming | |||
![Erik[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
