Thread: Concatenate
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Concatenate
=--(A1&B1&C1)
--
David Biddulph

Mac8128 wrote:
How can I concatenate three cells each with a number so that the
concatenated cell is a number, not text?

Example
A1 B1 C1 D1 (concatenated)
19 21 133 1921133


Reply With QuoteReply With Quote