first word

  1. M

    Segregating Sentences based on Identifying First Word

    Hello all, i have multiple sentences in column B, range is dynamic which has to be segregated based on identifying it's 1st word and has to be copied to column C and stacked under each other cell. The 1st word of each sentence falls under any of the format as follows. 1. Third character of the...
  2. S

    How to compare two lists by only the first word?

    I have two lists of company names in columns 1 and 2, and I want to see which companies in column 1 are already in column 2. However the company names are slightly different on the end, for example column 2 might have LLC or Co at the end while column 1 doesn't. Is there a way for me to compare...
  3. F

    VBA: Take first word from string (first word is seperated by a comma) and populate on different worksheet

    Hello All, I am needing to to take the first word of a string, each word in the string is seperated by a comma, and populate that first word into another column on a different worksheet using VBA. Source Sheet; "packagingData" Destination Sheet; "Template" The logic of what I need the macro...
  4. S

    Add comma after first word only

    I have an excel list of about 300+ names. Each name is in the same cell written as "LAST NAME FIRST NAME MIDDLE INITIAL" with no commas. (Ex. Doe Jane A). I need a way to insert a comma ONLY after the first word in the cell so it will read "Doe, Jane A". Is there any way to do this without...

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