separate names

  1. S

    Splitting data into several worksheets based on page breaks - help with VBA macro

    Hello, I am a novice when it comes to VBA - I can usually modify code that I find in forums such as these to get it to work for my circumstances, but I'm not great at creating my own. I'm hoping that someone can help me with a macro to split some data into separate worksheets based on page...
  2. D

    Can I separate cells with varying name data?

    I have an excel sheet that I need to separate out. I've already got the city/state issue solved, but I have a "name" cell that contains varying data ie) a1= Dr Joe Smith a2= dr and mrs john adams a3= mr greg j. Johnson I need to separate it out as simply as possible....any suggestions? I have...
  3. K

    How do you separate numbers and words of varying lengths into columns in Excel 2003?

    How do I separate the Fund Name, Ticker and Net Flows in this list, which are currently in one column, into three separate columns with Excel 2003? I got it from this site, ETF Fund Flows Tool - IndexUniverse.com, and wanted to reproduce it for a newspaper publication. I couldn't find an...
  4. H

    Extract last word from a cell value

    I am having 'NAMES' in column X5:X9999. NAMES contains 4 words MAXIMUM of alphanumeric characters separated by either a blank or "/" or "-". How to get the last word from the NAMES? All output required in UPPERCASE only in column Z5:Z9999 Ex: PETER ENGLAND...
  5. J

    Separating names into rows using formulas

    I have thousands of names I need to separate into rows using formulas. This will be a challenge because of the naming format: I have it MOSTLY down but I'm stuck because my first names get put into the middle name column when there is no middle initial. SAMPLE DATA: A B C D Full Name First...

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