Merging cells in excell
Closed
Ady
-
Feb 23, 2010 at 03:30 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 23, 2010 at 03:55 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 23, 2010 at 03:55 AM
Related:
- Merging cells in excell
- Number to words in excel - Guide
- Gif in excel - Guide
- How to take screenshot in excel - Guide
- Excel macro to create new sheet based on value in cells - Guide
- Marksheet in excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 23, 2010 at 03:55 AM
Feb 23, 2010 at 03:55 AM
How are you merging ? Most probably the "02" is actually 2 and you have just formatted it to make it appear like 02
If that is the case you have to use Text
Lets say A1=1234
B1=2 (that you have formatted to make it appear like 02)
then in C1 , you can use
=A1 & Text(B1, "0#")
If that is the case you have to use Text
Lets say A1=1234
B1=2 (that you have formatted to make it appear like 02)
then in C1 , you can use
=A1 & Text(B1, "0#")
