EXCEL Move A1 to A2 in a formula
Closed
Hello,
I have a 9 digit zip code in column A. I need to phyically move the first 5 digits to column B cell by cell, i.e. A1 to B1, A2 to B2, etc. =Left(A1,5) visually displays the answer but I do not want the formula to remain I want the actual first 5 digits of the email to replace the formula.
I have a 9 digit zip code in column A. I need to phyically move the first 5 digits to column B cell by cell, i.e. A1 to B1, A2 to B2, etc. =Left(A1,5) visually displays the answer but I do not want the formula to remain I want the actual first 5 digits of the email to replace the formula.
Related:
- EXCEL Move A1 to A2 in a formula
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Excel grade formula - Guide
- Lava a1 reset code - Phones, PDA & GPS Forum
- Gif in excel - Guide
1 response
Anonymous User
Jun 6, 2011 at 09:28 PM
Jun 6, 2011 at 09:28 PM
Greetings,
Remember ...
Before any answer given on the forum, you should know that there are volunteers who give their time trying to solve user problems.
Therefore, it is specifically requested from Kioskea forum users to show their respect. For this, the use of polite expressions is a minimum.
https://ccm.net/apps-sites/internet-archeology/ccm/10131-terms-of-use-for-ccm-respect-for-others/#politesse
Say please, thank you, appreciate, grateful, regards, etc... is common practice when you want something especially help!
So re-write your message respecting the politeness charter by using these words and repost your message on the forum.
We trust that you understand.
Moderator
Remember ...
Before any answer given on the forum, you should know that there are volunteers who give their time trying to solve user problems.
Therefore, it is specifically requested from Kioskea forum users to show their respect. For this, the use of polite expressions is a minimum.
https://ccm.net/apps-sites/internet-archeology/ccm/10131-terms-of-use-for-ccm-respect-for-others/#politesse
Say please, thank you, appreciate, grateful, regards, etc... is common practice when you want something especially help!
So re-write your message respecting the politeness charter by using these words and repost your message on the forum.
We trust that you understand.
Moderator