Posted to microsoft.public.excel.misc

Vic

external usenet poster

Posts: 117

Split 10 alphanumerics into 3 cells

What is the formula to split 10 alphanumerics into 3 cells?
I have A2 = 1067035C03
I need B2 = 1067, C2 = 035, D2 = C03
Thank you.

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
Vlookup functions which could not recognise similar alphanumerics	Shawn	Excel Worksheet Functions	2	July 30th 08 01:39 AM
How to Split the contents of cells across multiple cells	anna	New Users to Excel	5	May 29th 08 02:47 PM
Split cells	texansgal	Charts and Charting in Excel	1	January 16th 08 07:12 PM
Ignore Non-Alphanumerics When Comparing Text	KelleyS	Excel Worksheet Functions	1	July 25th 05 11:09 PM
Average using alphanumerics	JohnT	Excel Worksheet Functions	4	December 3rd 04 07:49 AM

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

About Us

"It's about Microsoft Excel"