Extract named formulas and use them in another spreadsheet

[tntrush]

Hallo,

I have named several formulas and use them in my spreadsheet.

For example, through Insert → Names → Define, I created -among others- the “sum” formula which performs a sum up procedure.

Could I possibly extract all the formulas I created along with their names, in order to use them in another spreadsheet?

Even better, is there a way to store all the names and the corresponding formulas in a spreadsheet called “Formulas” and make it work from there? (probably not …)

I would appreciate your help.

Kind regards,

[mariosv]

We can make a try, I have not look at all, but it seems to work,because copying a cell using a named formula in other spreadsheet, copy also the named formula.

• Create a new blank sheet, in the spreadsheet with named formulas.
• Menu/Insert/Names/Insert - Paste all.
• Convert the formula names in formulas with Find&Replace:
  Select the column with formula names
  Search for: .*
  Replace with: =&
  More options, selected range, mark regular expressions.
• Open the second spreadsheet where you want the named expressions.
• Copy the arranged sheet in the second spreadsheet.
  Right-click on the tab, select copy/move.
  Select in Location the second spreadsheet.
  Ok.

The named formulas are in the second spreadsheet.
Some choices, delete in the second spreadsheet the new sheet (named formulas remain), hide this new sheet, or left as is.

[tntrush]

Thank you Mariosv!

Indeed, the named formulas are in the second spreadsheet.

How could I append them in the “Insert->Names->Define” table?

Should I do it manually or there is a way to append them at once?

I need to do that, because the formulas contain other formulas. For example:

=CONCATENATE("<tr class=""mprow_title""><td

colspan="“3"”
class="“mpcell1"”>",OFFSET(INDIRECT(ADDRESS(ROW(),COLUMN())),0,2),"")

Which grubs the contents of the secondly next cell and concatenates them in the predefined text.

Kind regards,
tntrush

[mariosv]

If you can use in the second spreadsheet then they are there, do not need to redefine.
Menu/Insert/Name/Manage (Ctrl+F3) to see all named ranges/formulas.

To concatenate text or cells is easier use the & than the CONCATENATE() function.
i.e. ="Hello "&A5&named_formula