# Help in creating a formula

P

#### Pascale

Hello,

I would like to have a formula in E2 (The comment row) that would recognize
the 3 digits in B2, and copy it in E2.

My problem is that I need for the person to enter in E2 PW and have the 159
write itself right away, re3cognizinf what was inputed in Â»B2 and then the
person would go on with for example 203. So in the cell E2 I would get
PW159203.

4 digits 3 digits 5 digits Voir (*) Comment Nom du projet / Project
4450 159 DKxxx 1000 PW159203 CSeries
Thank you in letting me know if this is possible.

J

#### Jim Thomlinson

That could be done with macros but it can not be done in formulas. As soon as
the users types n cell E2 they are overwriting any formula that may be in
there...

J

#### Jim Thomlinson

Depends... Assuming you have 2 letters followed by the 3 digits and then the
remaining digits added on you could use a formula similar to this in an

=LEFT(E2, 2) & B2 & MID(E2, 3, 256)
Now type PW203 in E2 and the formula will return PW459203