bubbapost
06-21-2011, 04:31 PM
Hello,
I have a CSV file that a specific system spits out with thousands of rows of data and it's all seperated by a funky character, a square with a question mark in it. I can't figure out how to type that character in the "Other" portion as a delimiter.
I have attached a sample spreadsheet as an example.
I have also tried VBA, but I still need to know how to reference the character. Here is my code below:
Sub DelimTextToColumn()
Cells.Replace What:="", Replacement:=",", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub
Any help would be much appreciated!
I have a CSV file that a specific system spits out with thousands of rows of data and it's all seperated by a funky character, a square with a question mark in it. I can't figure out how to type that character in the "Other" portion as a delimiter.
I have attached a sample spreadsheet as an example.
I have also tried VBA, but I still need to know how to reference the character. Here is my code below:
Sub DelimTextToColumn()
Cells.Replace What:="", Replacement:=",", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub
Any help would be much appreciated!