How can I replace multiple data in excel ?

Posted to microsoft.public.excel.misc

Nanou

Posts: n/a

How can I replace multiple data in excel ?

Hi there,

I am trying to replace multiple data in excel. Let's say I have couple of
cells with value 1301 .....1320, I need to replace only the first 2 digits
....meaning I should have 1601.......1620.

Tried multiple ways but did not work.......any help will be greatly
appreciated!!!!

Thx.

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
Replace data by VALUE or COMMENTS not availabel in Excel 2003 ???	MCP	Excel Discussion (Misc queries)	6	December 19th 06 04:14 PM
How to paste data into multiple cells in Excel	wrdennig	New Users to Excel	4	April 20th 06 06:43 PM
Extract MS Excel Data embedded in MS Word	qualityprocess	Excel Discussion (Misc queries)	0	April 20th 06 05:52 PM
consolidation of tables in excel with text and figures	samenvoegen van sheets	Excel Worksheet Functions	8	March 2nd 06 03:27 PM
how do i link data from multiple standardized excel files	George	Excel Discussion (Misc queries)	2	April 14th 05 05:12 PM

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

Menu

About Us