How to append text to cell data ...

[ltf3]

HI

I have a column in Excel (Mac) with data file names. None have a file 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

Lee

[reybie]

I'd use the CONCATENATE() function.

=CONCANTENATE(A1, ".wav")

Then copy to all the other cells.

[Dave Peterson]

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

=a1&".wav"

and drag down the column

ltf3 wrote:
>
> HI
>
> I have a column in Excel (Mac) with data file names. None have a file
> 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
>
> Lee
>
> --
> ltf3
> ------------------------------------------------------------------------
> ltf3's Profile: http://www.excelforum.com/member.php...o&userid=27879
> View this thread: http://www.excelforum.com/showthread...hreadid=473813

--

Dave Peterson

[Beege]

You could format cells, custom,

@".wav"

No New column, no changes

Beege


"ltf3" <[email protected]> wrote in message
news:[email protected]...
>
> HI
>
> I have a column in Excel (Mac) with data file names. None have a file
> 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
>
> Lee
>
>
> --
> ltf3
> ------------------------------------------------------------------------
> ltf3's Profile:
> http://www.excelforum.com/member.php...o&userid=27879
> View this thread: http://www.excelforum.com/showthread...hreadid=473813
>

[reybie]

I like that @.wav