Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Everyone
Below are my codes that I use to clean my data coming from the internet. They all work except the first one (Find all the commas "," and replace with a period (.) ) Can anyone tell me why? Option Explicit Sub Clean_Data() Range("J3:L60").Select Cells.Replace What:=",", Replacement:=".", LookAt:=xlPart, SearchOrder _ :=xlByColumns Range("J3:L60").Select Cells.Replace What:="$", Replacement:="", LookAt:=xlPart, SearchOrder:= _ xlByColumns Range("J3:L60").Select Cells.Replace What:=" ", Replacement:="", LookAt:=xlPart, SearchOrder:= _ xlByColumns ' ALT-0160 Range("J3:L60").Select Cells.Replace What:=" ", Replacement:="", LookAt:=xlPart, SearchOrder:= _ xlByColumns End Sub Regards John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
between commas | Excel Programming | |||
Excel - Find and Replace from rows to separation by commas | Excel Discussion (Misc queries) | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
Period to Period percentage change? | Excel Discussion (Misc queries) | |||
Replace dot with commas | Excel Programming |