Replacing automatically

[adrianfleming]

I am trying to update a large range of entries (about 1,500
automatically. For example the entry 12345 I need to copy into a ne
column and change it to 12345.eps .Does anybody know a way to do thi
as the replace function does not seem to have an option to do this.
am using Excel on a Mac OSX if that helps but I can use a PC with XP i
require

 

[scottymelloty]

=CONCATENATE(A1,".eps")

A1 being whatever data you want to add .eps t

 

[ob3ron02]

Or alternately:

in B1, put in the formula = $A1 & ".eps" and then drag down to creat
the appropriate formula in column