Junior Member

Posts: 2

Formatting AlphaNumeric string in a cell

Is there a way similar to the Number custom format to break up an alpha numeric string with periods? For example, make 1422D21200 read as 14.22D2.1200.66014.0000.0000.0000

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
random alphanumeric string	[email protected]	Excel Worksheet Functions	4	April 21st 23 09:04 AM
Extracting numbers from alphanumeric string	Ales	Excel Discussion (Misc queries)	0	January 11th 10 03:17 PM
Obtain numeric from alphanumeric string	Manj	Excel Discussion (Misc queries)	3	March 14th 08 01:28 PM
Comparison of alphanumeric string	ErExcel	Excel Discussion (Misc queries)	4	May 7th 07 02:14 PM
How do I replace last numeric string from a alphanumeric string?	Christy	Excel Discussion (Misc queries)	3	August 11th 06 12:17 AM

All times are GMT +1. The time now is 06:51 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us