View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Marvin P. Winterbottom Marvin P. Winterbottom is offline
external usenet poster
 
Posts: 34
Default Changing large amount of Data

edit / replace / replace - with: leave it blank

"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