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
 
Mary

In B1 enter =IF(A1<>"",RIGHT(A1,2),"")

Gord Dibben Excel MVP
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for Bank Reconciliation 2
Matching unordered list 3
Data Validation Question 3
Find partial match from column A,B and fill partial match in C? 4
Counting the number of different entries in a column 2
SUMPRODUCT to return date of last payment? 7
Copy and Paste Help 2
Missing Cheque numbers in a bank book 8

Back
Top