Hello,
I am fairly new in all calc editing so i need some help.
Every week i get a table that should be edited. In that table i need to rename values in one column. Is there a function or something else that would rename various values to same one, example, rename BCD, DCA, ACD all to ABC. And i need to save it somewhere so i can use it every time i need it.
You can use Menu/Edit/Find & replace and quicker using regular expressions.
Hi
Allow me to add just two tips:
- Your Find & Replace dialog may be different (character width, japanese, CTL…) if you have not enabled Tools▸Options▸Language Settings▸Languages▸Asian & Complex layout (CTL) (Not matter, these options are not necessary in your case)
- Use something like
\b(BCD|DCA|ACD)\bin the Find textbox if you do not want to replace e.g.BCDinABCDE
Regards