How to append text to cell data ...

  • Thread starter Thread starter ltf3
  • Start date Start date
L

ltf3

HI

I have a column in Excel (Mac) with data file names. None have a fil
extension....
eg PD102310

I need to append the text ".wav" to every cell (over 10,000 of them
without touching the exisiting name.

Can anyone tell me how to do this???

Thanks in advance

Le
 
I'd use the CONCATENATE() function.

=CONCANTENATE(A1, ".wav")

Then copy to all the other cells
 
I'd use another column and fill it with formulas that used the & operator:

=a1&".wav"

and drag down the column
 
Back
Top