I am using the Concatenate funtion to combine 3 columns of text, however 1 column has a number in it, which produces a VALUE error. Is there a way to convert a number to text. If I put in an apostrophe, this does work but I have 200 rows and dont want to have to insert an apostrophe before every cell ???