Data Problem

orasuman7 · Newbie Joined: 21 Apr 2008 Posts: 3 Location: Bangalore

Hi Team

I have 10000 records like
FistName LastName Company ......... Date

In that i want to do change the ASCII values like (&,^,!...) and also /
i change all the values in teh excell
My Problem is when i change the / value it also change in Date like

DD/MM/YYYY SS:MM
23/10/2008 10:00 to 23 10 2008 10 00
If i
change the format also it is not working
and i did in blank space i menssion as / and it come to 23/10/2008/10/00
and manualy i change the all date file it well take 3day to change

Plz help in easy process

Regards
Suman
_________________
Regards
Suman

keme · Posted: Fri May 30, 2008 4:21 am Post subject:

I assume that all the dates (those you want preserved) are in separate columns. In that case...

Solution
Select the columns where you want substitution.
Then in the find/replace dialog, select More options and tick Current selection only.