Differences

This shows you the differences between two versions of the page.

--- microsoft_excel:macro_text_to_columns [2020/11/15 21:12] – created peter
+++ microsoft_excel:macro_text_to_columns [2021/08/04 14:27] (current) – removed peter
@@ Line 1: / Line 1: @@
-====== Microsoft Excel - Macro Text to Columns ======
-<code>
-Range("B1")= "First Name"
-Range("C1")= "Last Name"
-Range("A2",Range("A2").End(xlDown)).TextToColumns _
-Destination:=Range("B2"), DataType:=xlDelimited,Space:=True
-Columns("B:C").AutoFit
-Range("A1",Range("A1").End(xlDown)).Copy
-Range("B1",Range("B1").End(xlToRight).End(xlDown)).PasteSpecial _
-Paste:=xlPasteFormats
-Application.CutCopyMode= False
-</code>