|
Help in creating a formula
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. |
Help in creating a formula
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... -- HTH... Jim Thomlinson "Pascale" wrote: 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. |
Help in creating a formula
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 adjacent cell =LEFT(E2, 2) & B2 & MID(E2, 3, 256) Now type PW203 in E2 and the formula will return PW459203 -- HTH... Jim Thomlinson "Pascale" wrote: Ok so how would I go about doing this? "Jim Thomlinson" wrote: 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... -- HTH... Jim Thomlinson "Pascale" wrote: 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. |
Help in creating a formula
Alright, this did not work, Is there a full guide to help me in doing this?
"Jim Thomlinson" wrote: 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 adjacent cell =LEFT(E2, 2) & B2 & MID(E2, 3, 256) Now type PW203 in E2 and the formula will return PW459203 -- HTH... Jim Thomlinson "Pascale" wrote: Ok so how would I go about doing this? "Jim Thomlinson" wrote: 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... -- HTH... Jim Thomlinson "Pascale" wrote: 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. |
| All times are GMT +1. The time now is 05:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com