Merging cells in excell
Closed
Ady
-
23 Feb 2010 à 03:30
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 23 Feb 2010 à 03:55
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 23 Feb 2010 à 03:55
Related:
- Merging cells in excell
- Merging twitter accounts - Guide
- Student position formula in excel ✓ - Office Software Forum
- Count number of occurrences in excel - Guide
- Datatable to excel in asp net c# - Programming Forum
- Merging instagram accounts ✓ - Instagram Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
23 Feb 2010 à 03:55
23 Feb 2010 à 03:55
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#")
