Hi Henk,

=B1&A1

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Henk" wrote in message ...
|I have a numeric field and I want to make an alfanumeric field.
| If I have column a with numeric and column b with alfanumeric, how do I
| combine them in coloumn c?
|
| example
|
| a b c
| 100 nj nj100
|
| Thanks
|
| Henk