One way is to insert a helper column, add the text you want.

Say your data is column A.

Insert a new column B:
In B1, put this formula
="Croco" & A1
Then drag that formula down column B as far as you need.
I might use:
=if(a1="","","Croco") & A1

Then select column B
edit|Copy
Select A1
Edit|Paste special|Values
Delete column B

Croco wrote:

hi all,

is there a formula to add characters to all fields in a column?

like add Croco at the beginning of each cell all along the column...

Thank you in advance
--
Croco

--

Dave Peterson