string extracting split

  1. J

    Switching position of last name & first name strings without affecting position of an existing middle name string

    My data shows employee names in the following convention; lastname middlename firstname e.g. Persie Van Robin. I need to format the order of the name so that it appears as firstname middlename lastname e.g. so it appears as Robin Van Persie. A middlename will in many cases not exist. My macro...
    • jnathan
    • Thread
    • macro string extracting split string formating swapping switch values of cells
    • Replies: 18
    • Forum: Excel Questions
  2. P

    count how many times a word is repeated within a cell and build new simplified name strings

    Hi, I have a list of several thousand items, which consist of several different names together like this: Mr P Thompson & Mrs S Thompson & Mr A Thompson Mr C Guy-Johnson & Mrs A Guye-Johnson & Miss J Guye-Johnson Mrs Fuller & Ms D Fuller & Dr K U Fuller Dr V Patel & Dr OO Patel Mr B Burden &...
    • pwl2706
    • Thread
    • excel excel formula string extracting split worksheet function
    • Replies: 6
    • Forum: Excel Questions
  3. P

    Excel formula to split complex names

    Hi all, I have been tasked with some string manipulation and today must be my bad head day as it is proving more difficult than I expected. I have to take the initials of the first and second and third name from the first and second and third columns along with any surnames The reason is we...
    • pwl2706
    • Thread
    • excel 03 excel formuals string extracting split
    • Replies: 4
    • Forum: Excel Questions
  4. H

    Extract text from string (complex rules)

    Hi, can anyone please help me with this problem? It has been driving me crazy for days! I have a column with data in the following (ideal) format: texttextexttext/s2 texttextexttext/s2/c14 texttextexttext/s24/c2 and need a VBA solution to automatically split it across 3 columns, i.e column1...

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