authors

  1. N

    Remove all authors name from Excel

    At this link I did not get an answer to my question. Maybe I'll have more luck in this forum. It is common knowledge that with SaveAs in the (MS Office) window you have the option to enter the author before saving the Workbook. Just type in one letter and Excel will list all the authors that...
  2. M

    Break up a cell....

    I am working on a bibliography. (EndNote) I am converting it to excel. The Author cell looks like this: <tbody> Akil, Ali, Ziegeler, Stephan, Reichelt, Jan, Semik, Michael, Müller, Marcus Christian and Fischer, Stefan Several questions: How do I break up the authors and get rid of...
  3. A

    If one cell contains

    I am looking for a help is creating the macro code for If cell a contains certain text then cell b should update certain text authors for the dynamic range Please help
  4. E

    Adding comments automatically

    Hi, before i start to explain my problem, I'm a complete rookie when it comes to VBA, however I've got a fair amount of knowledge when it comes to formulas. I would like to know if its possible to add comments automatically, depending on the contents of the cell. For example the comment is...
  5. H

    Finding duplicate text in a single column containing multiple words in each cell

    I have a spreadsheet with authors of articles in one column. Many of the authors have several entries, and there are 100 rows total. For example [ Author t, Author u, Author v] [ Author x, Author Y, Author z] [ Author A, Author b, author x] I have to find out how many times the authors are...
  6. Csibész

    Can VLOOKUP be fine-tuned?

    Hi, Given a large number of books to label and sort in a small library. Authors and titles are in an Excel2010 workbook under win7 OS. Strings are grouped in alphabetical categories (Ygroup table). Using VLOOKUP function, the authors are assigned id#s as per the Ygroup table categories. For...

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