Thread: Concatenation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Muthalaly Muthalaly is offline
external usenet poster
 
Posts: 5
Default Concatenation

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