LibreOffice

LibreOffice - adding prefix/sufix to cells

click on the column to highlight the entire column of item numbers
go to "Edit" then to "Find and Replace"
enter a period and an asterik ".*" into the search for area to search for everything (quotes not needed)
enter any characters to be the prefix followed by an ampersand "&" (quotes not needed)
select "More options" for expanded options
makes sure "current selection only" and "regular expressions" are checked
if in a column, search direction will be rows and vice versa.
select "REPLACE ALL"

What I came with as basic idea, HalfPixel transformed into complete web.

Richard Rybnicek, pozdravdoneba.sk

When you`re not far, come visit us.