Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello, I have code that extracts certain things from a text file
containing source code for a web site. One of the things I am extracting is the web page name. For some reason it extracts it with a LOT of carriage returns. Like 7-8 of those rectangular characters. I have in my code the following: Cells.Replace What:=Chr(13), Replacement:="", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False Cells.Replace What:=Chr(10), Replacement:="", LookAt:=xlPart, SearchOrde:=xlByRows, MatchCase:=False But it only seem to delete like the first and last 2 of the characters...I can't figure out how to get rid of them. I figured if I also put something in the code along the lines of "If not alphanumeric then delete character (not entire cell)" Any suggestions?? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
File names appended with ~ plus alphanumeric characters | Excel Discussion (Misc queries) | |||
HOW DO YOU COUNT ALPHA CHARACTERS IN AN ALPHANUMERIC FIELD | Excel Discussion (Misc queries) | |||
Identify non-alphanumeric characters within a cell in Excel | Excel Programming | |||
Search for non alphanumeric characters | Excel Programming | |||
Strip Alpha Characters out of an Alphanumeric Dataset | Excel Programming |