View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Muthalaly Muthalaly is offline
external usenet poster
 
Posts: 5
Default Concatenation in Excel

Hi,
I am trying to concatenate two fields in excel.In this one field is a cutom
number field .When I am doing the concatenation I am losing the zeros before
the number.
Example 00123 + abc I am getting a result of 123abc .But I am looking
forward to get 00123abc. Is it possible in excel?Please help.