Cut characters from one cell to form a newcell

[Abay]

Hello,

I have a cell that contains an address line, plus a postal code (zip code).
The postal code is 7 characters long and is always at the end of the address
line.

I need to place the postal code in another new cell .. would like to create
a macro to do this and would appreciate any help on this.

Abay

 

[Guest]

You don't really need a macro to do this, unless it's something you do over
and over. Try turning on the macro recorder and recording the actions you
take as a start.

To get the right 7 characters of a cell use this:

=RIGHT(A1,7)

HTH,
Barb Reinhardt

 

[Abay]

Thank you very much for your reply & I will do as you say ... much
appreciated.

Abay