Adding Text To Text

S

SamuelT

Hi all,

I have a long list of projects names and I need to add the same tex
addition to the lot. Currently the project names are simply displaye
as:

PROJECT NAME

I need to change each entry to:

[PROJECT NAME.xls]

Can anyone suggest a means of doing this which doesn't involve goin
through each and typing the [] and.xls?

TIA,

Samuel
 
N

Niek Otten

If your text is in column A, insert a new column B
In B1: ="["&A1&"].xls"
Copy down as far as needed.
If you want to restore your original layout: Copy column B, Select A,
Edit>Paste Special, check Values.
You can now delete column B.

It is wise to save your work before doing all this!
 
Top