Thread: combine two numbers -- not add
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
  
Posts: 1,104
Default combine two numbers -- not add
Have you tried =A1&B1 ?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"KevinS" wrote in message
...
I want to take the numbers from two columns and combine - but them. For
instance:

Column A = 01
Column B = 101
Column C will equal 01101
What function will i use to achieve this?
Thank you,
Kevin
--
Is it the times or the Zeitgiest?


Reply With QuoteReply With Quote