Posted to microsoft.public.excel.misc

Oystein

Posts: n/a

Split or delete part of a number

I got a row that contains numbers with 11 digits, I need to delete or move
out the last five so I can make the first six a date.
Any good ideas?

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
How do I delete part of a text string in every cell it appears in	Chacky	Excel Discussion (Misc queries)	3	December 9th 05 07:06 PM
I need help with an "If" Statement	Whayne	Excel Worksheet Functions	3	July 20th 05 09:25 PM
Part Number Lookup	Marshall2	Excel Worksheet Functions	2	July 11th 05 08:58 AM
duplicate number	Daniell	Excel Discussion (Misc queries)	1	March 16th 05 07:02 PM
Part Number/Qty Consolidations	[email protected]	Excel Discussion (Misc queries)	2	February 6th 05 09:21 PM

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

About Us

"It's about Microsoft Excel"