Posted to microsoft.public.excel.misc

Posts: n/a

Split the numbers in a alpha numeric case

I have the following Number format in one row

132-45-69 N.

I want to split the numbers in three different rows like 132 in one row,45
in another and 69 in the third row.

Can this be done in excell

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
how to use spellnumber formula	Aarif	Excel Worksheet Functions	3	February 27th 06 04:36 PM
Currency to Text	mytipi	Excel Worksheet Functions	1	February 21st 06 11:43 PM
VBA	Monty	Excel Worksheet Functions	2	January 30th 06 01:37 PM
VBA Code	Cell Mate	Excel Discussion (Misc queries)	4	January 9th 06 08:52 PM
Loop for VBA code?	paulinoluciano	Excel Worksheet Functions	5	December 28th 05 01:30 PM

All times are GMT +1. The time now is 09:53 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us