add nummeric and alfa to one alfanumeric number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
try =B1&A1
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
Hi Henk,

=B1&A1

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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
 
Back
Top