Posted to microsoft.public.excel.newusers

external usenet poster

Posts: 3

Replacing numbers

I have a spreadsheet which contains 6 digit numbers (i.e.209111, 209112,
209113).
I would like to perform a bulk replace for just the first 3 numbers.
Turn 209*** into 210***.
Any suggestions?
Thanks,
Randy

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
replacing a range of numbers	sg	Excel Worksheet Functions	3	August 14th 08 01:45 PM
Replacing a Range of Numbers	Peter Herman	Excel Worksheet Functions	1	July 10th 08 10:30 PM
replacing numbers in a cell	catspore	Excel Worksheet Functions	5	May 8th 07 04:34 PM
Replacing specific numbers	jezzica85	Excel Discussion (Misc queries)	2	May 5th 06 12:16 AM
using treater than and replacing numbers	mja	Excel Worksheet Functions	1	March 23rd 05 05:59 PM

All times are GMT +1. The time now is 08:32 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us