How can I generate a General Ledger code

J

JJohnn

I have several company numbers (e.g. 3), account numbers (e.g. 9999) and
dept numbers (e.g. 5) - how can I read arrays of these numberbers to generate
GL codes in the format "3-999-5"?
 
F

Frank Kabel

Hi
how are the original numbers stored in Excel?.
You may use a formula such as
=A1 & "-" & B1 & "-" & C1
 
Top