Re: Concatenate Text Fields

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Pardon me for bumping in, but I was able to get the formula:

[Number1] & ":" & [Number2]

to work without difficulty and without the need to convert to a
string in both Project 2003 as well as Project 2007. The formula is
written in a text field. Is it possible that your reference to
[Num1] in your original formula was not referring to the correct
field name? There are no fields named [Num1] in Project only
[Number1].

There is nothing wrong with your formula as long as the number
strings don't exceed 6 characters, if they do you'll need to
remember to edit the formula.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

"JasonHik" <JasonHik.40m63b@xxxxxxxxxxxxx> wrote in message
news:JasonHik.40m63b@xxxxxxxxxxxxxxxx

Thanks Rob,

The string() function is MS Project does not appear to be the
right
function, but taking your lead I used the following;

Left([Number1],6) & ":" & Left([Number2],6)

which appears to work.

Many thanks for the tip on the number being a string.

Jason


--
JasonHik
------------------------------------------------------------------------
JasonHik's Profile: http://forums.techarena.in/members/148452.htm
View this thread:
http://forums.techarena.in/microsoft-project/1262912.htm

http://forums.techarena.in



.

Quantcast