help on excel.....

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • madhurjya
    New Member
    • Nov 2007
    • 14

    #1

    help on excel.....

    does any one have any idea to replace image to excel cell containing any text.
    say i have a excel sheet containing data like "test" in many cell.So now i want to replace the test word with a image like sample.jpg. Can i do this....please help...
  • sicarie
    Recognized Expert Specialist
    • Nov 2006
    • 4677

    #2
    Did you try doing a 'Find and Replace'? This is usually under the edit menu. In that menu there should be a 'replace all' button.

    Caveat: this may replace words like (using your example) Stresstesting with Stresssample.jp ging (replaces test with sample.jpg, even inside a word). So be careful with the "replace all" feature - you might want to test it first.

    If so, Python can open and manipulate Excel spreadsheets - try using that to parse for only ' test '. I think Perl and Ruby are able to do this as well.

    Comment

    Working...