There's no formulas. I'm not sure what a delimiter is.The reason I'm doing this is becuase someone else exports the files from Access to Excel which puts everything in text. The columns have text and numbers and the only way I can figure out to have the numbers as actual manipulatible (sp?) numbers is to use the "text to columns" function. However, I'd have to do this for 400 columns and was hoping to get around it by looping a macro.
Here's the VBA I have but it keeps pasting the results in cell "B1".
Do Until ActiveCell.Columns = " "
Selection.TextToColumns Destination:=Range("B1"), DataType:=xlDelimited, _
TextQualifier:=xlSingleQuote, ConsecutiveDelimiter:=False, Tab:=False, _
Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
:=Array(1, 1), TrailingMinusNumbers:=True
Video Tutorials / Excel Dashboards Reports