Need help with formula/macro

In the attached photos you see my colleagues table that is all codes in one box. And the other is mine where it's divided up in to nice columns. What type of macro can I use on my colleagues rappor...

excel

Formulas and Functions

HansVogelaar
Jun 13, 2023
Excel_newbie23

Interactively:

Select column A.

On the Data tab of the ribbon, click Text to Columns.

Select Delimited, then click 'Next >'.

Under Delimiters, tick the check box for Comma and clear the rest.

Click Finish.

In a macro:

Sub SplitData() Range("A:A").TextToColumns _ DataType:=xlDelimited, _ ConsecutiveDelimiter:=False, _ Tab:=False, _ Semicolon:=False, _ Comma:=True, _ Space:=False, _ Other:=False End Sub

HansVogelaar

MVP

Jun 13, 2023

Excel_newbie23

Interactively:

Select column A.
On the Data tab of the ribbon, click Text to Columns.
Select Delimited, then click 'Next >'.
Under Delimiters, tick the check box for Comma and clear the rest.
Click Finish.

In a macro:

Sub SplitData()
    Range("A:A").TextToColumns _
        DataType:=xlDelimited, _
        ConsecutiveDelimiter:=False, _
        Tab:=False, _
        Semicolon:=False, _
        Comma:=True, _
        Space:=False, _
        Other:=False
End Sub

Excel_newbie23

Copper Contributor

Jun 13, 2023

Thank you so much for the help! 🙂

Forum Discussion

Need help with formula/macro

Resources