Use the formula =LEFT(B2,4) and fill down in the No. column. This assumes
that BU# is in column B; adjust to suit your needs.

Dave
--
Brevity is the soul of wit.


"frustratedwthis" wrote:

This is probably an easy one...and I'm sorry :)
No. BU # Amt.
? 21000 $15.00

I would like to format the no column to only bring over the first 4 numbers
from the BU column...
Is this possible?

Thanks in advance!!