Posted on Nov 20, 2013 3:27 AM, Excel Help Forum | www.excelforum.com
Some one at the office did the following before but they are not here any more and I need to create an account number using two data from two cells.
Lets say 'A1' 901359 'A2' PA
I need it to look like
Any help out there.
Do I merge the cells first into one then use a different formula to add the '-'?
Thanks for the help!!!!