Computing.Net > Forums > Programming > I want to replace datas in excel.

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Click here to start participating now! Also, check out the New User Guide.

I want to replace datas in excel.

Reply to Message Icon

Name: rama86
Date: March 24, 2009 at 13:48:10 Pacific
OS: Windows 2000
Subcategory: General
Comment:

I want to replace all the special characters in the excel sheet with the help of some unix command is that possible?

We have to do some repeated work of replacing all the special characters in the excel sheet with space i have to automate it with some commands. Please help.




Response Number 1
Name: Mike (by mmcconaghy)
Date: March 24, 2009 at 15:40:43 Pacific
+1
Reply:

What special characters are you talking about?
I wasn't aware that Execl accepted any special characters as input.

MIKE



Response Number 2
Name: rama86
Date: March 26, 2009 at 10:47:09 Pacific
+1
Reply:

The special characters are ! @ # $ % ^ & ( )

These characters has to be replaced by space. Could you please help me for that.



Reply to Message Icon

Related Posts

See More


Batch file loop Compiler error with DEV-C...



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Programming Forum Home


Google Ads



Results for: I want to replace datas in excel.

Batch file to replace text in file www.computing.net/answers/programming/batch-file-to-replace-text-in-file/20070.html

Ask about FillRect() and print data in t www.computing.net/answers/programming/ask-about-fillrect-and-print-data-in-t/2582.html

How to show data in DataGrid www.computing.net/answers/programming/how-to-show-data-in-datagrid/8864.html