Trying to truncate or separate the first 3 characters/digits of co

Posted to microsoft.public.excel.misc

Jim

Posts: n/a

Trying to truncate or separate the first 3 characters/digits of co

I have a spreadsheet with a column of numbers. I'm trying to extract /
truncate / remove the leading 3 digits in each cell. The numbers vary in
length, so using the LEFT or RIGHT function doesn't seem to be an option.

The numbers represent division / dept. numbers within my company. The
leading 3 digits represent the division, which I want to remove / discard.

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
Separate first and second name in one cell into separate cells.	Dwight in Georgia	Excel Discussion (Misc queries)	3	January 25th 06 09:09 PM
Open Excel files in separate sessions, not just separate windows?	Bob at Dexia Design	Excel Discussion (Misc queries)	1	October 18th 05 05:46 PM
Open separate window	Robbin	Excel Worksheet Functions	2	September 1st 05 01:03 PM
Divide worsheet and save as separate files	Colin Hayes	Excel Worksheet Functions	0	June 28th 05 09:42 PM
Separate first and second name in one cell into separate cells.	Gary's Student	Excel Discussion (Misc queries)	0	April 27th 05 11:11 PM

All times are GMT +1. The time now is 05:55 PM.

Menu

About Us