putting ' in a column of cells

P

Peter McCaul

I'm combining two cells with the = A1 & " " & B1 formula. The a1 column
has numbers in it and I can only get that formula to work if I put a ' in
front of the numbers. The column is about 300 cells long. Is there a quick
formatting way in which I can do this? Any help is appreciated. Thanks.
 
T

Tom Ogilvy

It should work fine without the single quote. If you want some special
format

=Text(A1,"00000") & " " & B1

Use the format you want.
 
Top