Posted to microsoft.public.excel.programming

Erik[_8_]

external usenet poster

Posts: 1

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Deleting characters that are not numbers	jermsalerms	Excel Discussion (Misc queries)	4	January 12th 06 08:06 PM
Deleting Blank Characters in a Cell	PokerZan	Excel Discussion (Misc queries)	4	June 3rd 05 09:43 PM
Deleting unneeded characters in a cell	Wally Steadman[_4_]	Excel Programming	1	December 29th 04 10:33 PM
deleting the last nine characters in a cell	Chris	Excel Programming	2	June 18th 04 04:03 PM
Deleting unwated control characters at the end in a particular column	ssexcel[_7_]	Excel Programming	4	November 15th 03 03:34 AM

All times are GMT +1. The time now is 07:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us