Posted to microsoft.public.excel.misc

external usenet poster

Posts: 43

How to arrange number?

Hi
I have a column of around 2000 customer mobile numbers, the numbers are
having space in between nad some numbers entered with two zero in the front.
How can i arrange all the numbers without zero in front and without any space
in between? please guide me with the easiest method

Thank u
--
Life isa journey not a destination

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
arrange data	Suri	New Users to Excel	2	November 24th 09 12:11 AM
Auto Arrange	Kanmi	Excel Worksheet Functions	2	June 23rd 09 09:56 PM
How do I re arrange numbers	Raz	Excel Worksheet Functions	3	November 12th 08 07:04 PM
Arrange Windows	Bean123r	Excel Discussion (Misc queries)	0	January 24th 06 09:35 PM
re-arrange text	snugs25	Excel Worksheet Functions	1	December 12th 05 01:16 PM

All times are GMT +1. The time now is 11:56 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us