Reading Data from other workbook

Hi

I have a sheet and need read some columns and rows from otther sheet and to import formatting (wihout "/" , "-" ...etc, for example 2005-3/99 will be 2005399).
Somebody know how can I do It, I never do it ?

You will need a comprehensive rule detailing the exact reformat operation. In the case you have put in your post using a recent version of Excel (will NOT work with Excel '97):

Code:

---

Option Explicit
Sub Macro1()
    Dim tStr As String
   
    tStr = "2005-3/99"
    tStr = Replace(tStr, "-", "")
    tStr = Replace(tStr, "/", "")
   
    'TEST TEST TEST TEST
    MsgBox tStr    'Shows "2005399"
    'END TEST
   
End Sub

---