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 ?
Printable View
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