Posted to microsoft.public.excel.misc

Gazz_85[_2_] Gazz_85[_2_] is offline

external usenet poster

Posts: 49

Replace Number

I have over 400 entries in a colomn which start with 0015...and then more
numbers.

how can easily edit on mass so that they now begin with only 015 ???

cheers

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 can I replace text with a specific number?	Emma O''Shaughnessy	Excel Discussion (Misc queries)	3	July 3rd 08 12:14 PM
remove and replace digits from a number	spreadsheet monkey	Excel Worksheet Functions	3	April 20th 07 02:08 PM
Replace variable row number in formulas	Ldub	Excel Discussion (Misc queries)	0	November 3rd 05 10:25 PM
Replace a number with text	Candy	Excel Worksheet Functions	1	October 3rd 05 05:49 PM
How do I replace a negative number with zero	Laura@Gage	Excel Worksheet Functions	4	March 9th 05 02:05 AM

All times are GMT +1. The time now is 10:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us