V
V
Vasya Bulka2015-04-24 04:50:24
excel
Vasya Bulka, 2015-04-24 04:50:24

How to translate the price into wiki markup + Excel?

Such a task: there is a price list .xlsx for 6k items.
Design: A - Product code, B - Everything else (name, characteristic description), C - Price
This price list should be transferred to the VK group.
And here is the first question, how or with what help to format the document so that from the beginning it was the Product Name, then the Code in brackets, example NAME (CODE)? Name (Code) - This is the future link/page in the group.
And the second question:
For example, there is a code:
{|
|1||aaa
|2||bbb
|3||ccc
|}
How to highlight all numbers at once, i.e. and use Bold text with '''x''' . ?
I think in MS word you can somehow replace it with the help of expressions, but which ones ...
Help, the second day I'm looking for an easy way, because if each product, the name will take a lot of time to edit.
No wonder they came up with a PC)
Print on the price and code9e8fa3e094134bb1aaf6d92db3318429.pnge9947469593f441cbdb2a917cac97e72.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
V
Vitaly Pukhov, 2015-04-24
@Anonymous24

Google shows Online tools for solving this problem http://excel2wiki.net/
This is quite possible with the help of formulas, but which ones specifically depend on what you want to get, I didn’t understand much about Wiki markup, if there is xls for an example and an example of wiki code for say 2 groups with 2-3 products it will be possible to write formulas

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question