Results 1 to 2 of 2
Thread: - Excel
Hybrid View
-
13th December 2010 16:21 #1Registered User
Join Date: Jul:2010
Location: Sofia
Posts: 22
- Excel
. 10 000 , xlsx, , , . , . , replace- (. ch ), (. v ), !
add in , ??
-
13th December 2010 21:52 #2
- . ( ).
, . :
, () .Code:Sub Macro1() ' ' Macro1 Macro ' ' Cells.Replace What:="ch", Replacement:="", LookAt:=xlPart, SearchOrder _ :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False Cells.Replace What:="a", Replacement:="", LookAt:=xlPart, SearchOrder _ :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False Cells.Replace What:="b", Replacement:="", LookAt:=xlPart, SearchOrder _ :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False Cells.Replace What:="v", Replacement:="", LookAt:=xlPart, SearchOrder _ :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False End Sub
, " ", " " " ". - .
GIGABYTE 890GPA-UD3H | AMD Phenom II X4 925 2.8GHz / CM HYPER TX3 | 2 x 2GB SUPER TALENT DDR III 1333 CL9 | Sapphire HD5770 Vapor-X 1GB GDDR5 | WD 500GB SATA II Black | CM GX 650W | LG W2361V-PF, 23", 1920x1080 | Windows 7 Ultimate x64




Reply With Quote
...
7th May 2023, 14:24 in