Adding to a cell

[Frank Z]

I have a column of cells (B2 through B850) that contain file names. I need to add a file extension to the file name in each of these cells.

I've used the following formula/function to add text to a cell that already has text in it:
="TEXT TO BE ADDED/"&A1

This works well but it puts the text ahead of the data that is already in the cell.

I need to add to the end of the data that is in the cell.

Anyone know how I can do this?

 

[Jonmo1]

Try

=A1&"TEXT TO BE ADDED/"

 

[Frank Z]

Too Easy!!

Thanks!!