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. |
Concatenation
hi
see your post under worksheet functions. most regulars here dislike double posting. Regards FSt1 "Muthalaly" wrote: 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. |
Concatenation
Please do NOT multi-post - you have answers elsewhere.
Pete On Jun 24, 12:24*pm, Muthalaly wrote: 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. |
All times are GMT +1. The time now is 01:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com