Previous Topic Next Topic

EXCEL Move A1 to A2 in a formula

Closed
Kent - Jun 6, 2011 at 06:14 PM
bionik Posts 4234 Registration date Thursday August 19, 2010 Status Moderator Last seen August 3, 2016 - Jun 6, 2011 at 09:28 PM
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.

1 reply

Answer 1 / 1
bionik Posts 4234 Registration date Thursday August 19, 2010 Status Moderator Last seen August 3, 2016
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
0