ExcelBanter - View Single Post

=A2&TEXT(B2,"00")&C2

"killertofu" wrote:

I am trying to make an auto-name generator for the computers at work and
I am trying to make it so that all I have to do is enter certain
information and it spits out a name. This will make my life a
hellaeasier.

Here's my cells...
A B C
1 NAME EMP. # COMPUTER
2 JOHN 01 DELL

Here's my two problems...
First of all, I try to use the concactenate function to bring the whole
thing together (JOHN01DELL) but it gives me a #NAME? error for JOHN and
DELL.

Secondly, I switched it to simple & combo function and when it combines
the three cells, it takes out the 0 in front of the 1, thus giving me
JOHN1DELL.

I would like excel to give me JOHN01DELL as an output, no matter what
function I use, so any help is welcome.

Thanks a lot peeps.

--
killertofu
------------------------------------------------------------------------
killertofu's Profile: http://www.excelforum.com/member.php...o&userid=31024
View this thread: http://www.excelforum.com/showthread...hreadid=512406