text to coumns

  1. W

    Help with separating data in VBA

    Hi Guys & Girls, I know there are a number of ways of splitting names by space, but i want to ignore the 2nd space. So if the name is John Fred Bloggs. I want it to be <tbody> John Fred Bloggs </tbody> I have 2 macros built- one is a text to columns and the other is below. But both...
  2. S

    Text to columns help for 6 columns

    I need to automate the following process and was told to start with getting the data from the PDF file into Excel and then use the Text to Columns to convert the data into a more user friendly format. I need to be able to split the data below into 6 columns. Each text grouping is separated by...

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