Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing semicolons
I have successfully cleaned my data up to the point
where ";" is are now at the beginning and end of the field. Please I need a macros (Office XP)to clean up this huge database. For example: ;PM;LE; to become PM;LE ;QM to become QM LE;QM; to become LE;QM |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing semicolons
Can you use something along the lines of:-
i = 1 Do Target = Range("D" & i) TargetLength = Len(Target) CharLeft = Left(Target, 1) CharRight = Right(Target, 1) If CharLeft = ";" Then Target = Right(Target, Len(Target) - 1) If CharRight = ";" Then Target = Left(Target, Len(Target) - 1) Range("D" & i) = Target i = i + 1 Loop |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing semicolons
Hi Ja,
If it is already in Excel do a Find/Replace, replace all. Pretty fast and easy, no code. Thanks "JA" wrote: I have successfully cleaned my data up to the point where ";" is are now at the beginning and end of the field. Please I need a macros (Office XP)to clean up this huge database. For example: ;PM;LE; to become PM;LE ;QM to become QM LE;QM; to become LE;QM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing text between hyphens and removing the hyphens | Excel Discussion (Misc queries) | |||
Removing #N/A | Excel Discussion (Misc queries) | |||
Removing #N/A | New Users to Excel | |||
Removing patterns without removing gridlines | Excel Discussion (Misc queries) | |||
Removing the +4 from zip+4 | Excel Discussion (Misc queries) |