How can I generate a General Ledger code

[Guest]

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"?

 

[Frank Kabel]

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

 

[Guest]

Works perfectly...you saved me a lot of time....thank you!