How to append text to cell data ...

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
 
R

reybie

I'd use the CONCATENATE() function.

=CONCANTENATE(A1, ".wav")

Then copy to all the other cells
 
D

Dave Peterson

I'd use another column and fill it with formulas that used the & operator:

=a1&".wav"

and drag down the column
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to append a character to cell data 1
Select cells with text 4
Populate cell with multiple non-blank text values 3
Append text to a cell in edit mode of excel sheet... 2
Locating differences in text when comparing two cells 10
Append text to each cell 4
how to return "summary" of all non-blank cells plus their headers 10
Numeric Field Overflow when appending date - how to convert it to text 1

Top