Adding prefix to a column.

paulketil · Newbie Joined: 03 Feb 2010 Posts: 2

I am going to copy some lists in to a database, and i have a column that consists of both numbers and text.
I want to add a prefix to that column and force the column to text format.

Have been searching the forum but cant find any solution for my problem.

Ex.

"123-1234-45"(Number format) ===> "112-123-1234-45"' (Text format)
"ADE-123-FG" (Text format) ===> "112-ADE-123_FG" (Text format)

BRG

Paul Ketil

Villeroy · Posted: Wed Feb 03, 2010 9:32 am Post subject:

IF(ISNUMBER(A1);TEXT(A1;"000-000-0000-00");A1)
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

stevesaunders · OOo Advocate Joined: 26 Dec 2009 Posts: 408

select the column / Format / Cells / Numbers / Text
_________________
Steve ~ Tennessee USA
Mac OS X 10.6.2 Open Office 3.1

paulketil · Newbie Joined: 03 Feb 2010 Posts: 2

Thank you Villeroy!

After some testing i found uot about it.

My solution vas:

IF(ISNUMBER(A1);TEXT(A1;"################");A1)

And after converting all cells to text i formatted the column "110-@"

Are there any way to add the prefix in the formula both for tekst and number cells?

PK

Villeroy · Posted: Wed Feb 03, 2010 11:36 pm Post subject:

A contanation gives text in any case:
="110-@"&A1