Prev: Default Alternate resource rate
Next: Deleting multiple rows from value list
From: Val on 8 Mar 2010 11:49
I'm new to Project so this may be simple. I have several project files that
the value list for a Text column was incorrectly entered. Is there a way I
can add a string prefix to all 200+ values in the list? For example, the
data I have in the Text13 column is "1.3.1" and I want "ABC.1.3.1". I've
tried to do a formula but I keep getting a recursive error since I need the
new value to be in Text13 plus I need to keep the ability to be able to
select a new value from the list (in case something changes). If it was
Excel, this would be simple because I'd just convert the formula to Paste
Values and be done.

Any help is appreiciated!!!
From: Jack Dahlgren MVP on 8 Mar 2010 13:37
You can copy the column, then paste in excel, convert then paste back.

-Jack Dahlgren

"Val" <Val(a)discussions.microsoft.com> wrote in message
news:6243DFE5-9996-4990-B6DB-AB5E04873E52(a)microsoft.com...
> I'm new to Project so this may be simple. I have several project files
> that
> the value list for a Text column was incorrectly entered. Is there a way
> I
> can add a string prefix to all 200+ values in the list? For example, the
> data I have in the Text13 column is "1.3.1" and I want "ABC.1.3.1".
> I've
> tried to do a formula but I keep getting a recursive error since I need
> the
> new value to be in Text13 plus I need to keep the ability to be able to
> select a new value from the list (in case something changes). If it was
> Excel, this would be simple because I'd just convert the formula to Paste
> Values and be done.
>
> Any help is appreiciated!!!

From: Val on 8 Mar 2010 15:19
Thanks that worked as long as I selected the 1st and last cell in the column.
I tried pasting the column but that locked up project.


"Jack Dahlgren MVP" wrote:

> You can copy the column, then paste in excel, convert then paste back.
>
> -Jack Dahlgren
>
> "Val" <Val(a)discussions.microsoft.com> wrote in message
> news:6243DFE5-9996-4990-B6DB-AB5E04873E52(a)microsoft.com...
> > I'm new to Project so this may be simple. I have several project files
> > that
> > the value list for a Text column was incorrectly entered. Is there a way
> > I
> > can add a string prefix to all 200+ values in the list? For example, the
> > data I have in the Text13 column is "1.3.1" and I want "ABC.1.3.1".
> > I've
> > tried to do a formula but I keep getting a recursive error since I need
> > the
> > new value to be in Text13 plus I need to keep the ability to be able to
> > select a new value from the list (in case something changes). If it was
> > Excel, this would be simple because I'd just convert the formula to Paste
> > Values and be done.
> >
> > Any help is appreiciated!!!
>
> .
>
 | 
Pages: 1
Prev: Default Alternate resource rate
Next: Deleting multiple rows from value list