Concatenation

M

Muthalaly

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.
 
F

FSt1

hi
see your post under worksheet functions.
most regulars here dislike double posting.

Regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenation in Excel 6
ASK Field Formatting 1
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Concatenating Currency and Percent 5
Select Text to End of Footnote 9
Page numbering with Merged Document and IF statements 1
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0

Top