View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Changing large amount of Data

Edit Replace

In the Find what field put -
In the Replace with field put nothing

Touch Replace All
--
Gary's Student
gsnu200701


"glnbnz" wrote:

I would like to simply change a large number of records in a spreadsheet
without having to change each one individually. Here is my example:
Befo 21-101-38468-00-00
Change to: 21101384680000
How can I do this? There are over 14,000 records
Thank you