Adding Text in front of other....

[bdepew]

I have a spread sheet and in one of the colums we have some text, well we need to add some text in front of each text in each cell in that column, is there a quicker way to do then manual? we have tons to do?

[BigBas]

Are you adding the same text to every cell in that column? If so, how about setting up a helper column.

Lets say you are working with column A, and you want to add "Yes" before every cell in that column. Insert a new column (Column B). In cell B1, enter:

="Yes"&A1

Then drag that formula down.

Let me know if that works.