Please Please Help with formula

  • Thread starter Thread starter Mary19
  • Start date Start date
M

Mary19

I've created a purchasing order form to which I need some help with.
Let's say that colum A is the 'Purchase Order Number', which is a
7-digit number, and column B is the 'Cheque Number' used to pay for
this order. Now, the cheque number is the last two digits in the
purchase order number. Is there any way that the last two digits from
Column A can be inputted into column B without doing it manually?
Thanks for any suggestions. :D
 
You could use data, text to column and fixed width of 5
characters. It will seperate the last two digits into a
seperate column for you. If you need to keep the original
7 digit number simply copy the column before doing text to
columns. Hope this helps.
 
Back
Top