splitting column

  1. A

    Coding for a question with multiple answers in Excel

    Hi, A thanks in advance to whoever replies I have a question in my project for which participants can select multiple answers. The data was obtained through google forms where the file was exported to csv for example for a question it may have answers like following Respondent 1 -...
    • achusp
    • Thread
    • coding data cleaning splitting column splitting data
    • Replies: 7
    • Forum: Excel Questions
  2. J

    Splitting a LONG Column

    I have split columns before using the (LEFT,RIGHT,MID) statements after finding a character, but this is my challenge. I have a column that has multiple "\" characters in variable positions and all the text between them and the last characters after the last "\" needs to be in separate fields...
  3. S

    Parsing decimal numbers from Text and putting it in separate column.

    Dear All, I have data in the following format in column A. Input looks like- row 1-Scottish Widows Investment Management Ltd 3,602,689 3.36 row 2-Banco Santander Central Hispano S.A. 9.62 Column A is a mixture of name(Scottish Widows Investment Management Ltd) and...

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