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
 
You could format cells, custom,

@".wav"

No New column, no changes

Beege
 
You must log in or register to reply here.

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
append a string of text to all cells in a column? 2
Select cells with text 4
Locating differences in text when comparing two cells 10
How to replace text with numbers? (formula) 3
Append text to a cell in edit mode of excel sheet... 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Back
Top