CONTATENATE

[MIKE D]

IS THERE A WAY TO CONCATENATE THE FOLLOWING
BX
0000100

WITHOUT LOSING THE LEADING ZEROS OR THE LAST ZEROS.

I NEED THE CELL TO READ BX0000100

MY LIST STARTS WITH 0000100 AND ENDS WITH 0919000
SO I NEED TO BE ABLE TO DO THIS IN ONE SWIFT COPY.

THANKS

 

[Frank Kabel]

Hi
first: please turn off your CAPS-Lock: Difficult to read and considered
as shouting in newsgroups.

Try:
=A1 & TEXT(B1,"0000000")