Posted to microsoft.public.excel.misc

Gord Dibben Gord Dibben is offline

external usenet poster

Posts: 22,906

Remove leading blank(s)

Yes, works with numbers

I assumed text for some reason.

Maybe a text day<g

Gord

On Sun, 17 Aug 2008 12:52:55 +0100, "Sandy Mann"
wrote:

Hi Gord,

I assumed that the OP was talking about numbers with a leading space. I
assume that it works for you with numbers?

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
Remove leading zeros	Machel	Excel Discussion (Misc queries)	9	February 14th 08 12:07 AM
remove leading zero from a string..	clegge	Excel Worksheet Functions	3	December 27th 05 09:04 PM
Remove leading space	Karidre	Excel Worksheet Functions	4	October 24th 05 03:39 PM
How do I remove leading zero in large DB?	sharonkturner	Excel Discussion (Misc queries)	6	March 23rd 05 02:52 AM
Remove Leading Spaces	Kirk P.	Excel Discussion (Misc queries)	3	March 3rd 05 01:30 PM

All times are GMT +1. The time now is 02:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us