one column to two

  1. W

    Split a column into two Columns in excel

    Hello Team, I have this below data in one cloumn. Cloumn A 119WATER:FYI0333 120MATTER:BYT0444 144CAUSE:PRI0345 I would like to split this data into the two column such as Cloumn A 119WATER 120MATTER 144CAUSE Column B FYI0333 BYT0444 PRI0345 Please advise me on this Thanks in Advance Cheers...
  2. W

    I can't seem to simply parse the first word of a column with the rest writing to a next new column.

    I found a solution here. But I can't get it to stop after the first space. E.g. Col A   Col B Col C Col D Col E Bob Scott   Bob Scott Bob Joe Scott   Bob  Joe   Scott Bob Joe Scott Jr.   Bob   Joe  ...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top