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

Hello,
I have inserted a 0 before a number in one cell then i ahve merged this cell with another the result i get is losing the 0
example 1234 merged with 02 results in 12342?
I need to keep the 0

Regards

Merging cells in excell
Merging twitter accounts - Guide
Gif in excel - Guide
Number to words in excel - Guide
Student position formula in excel ✓ - Office Software Forum
Based on the values in cells b77 b88 ✓ - Excel Forum

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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#")

Similar discussions

help me to add particular cells

Clear cell contents based on value of another cell range using VBA

Fill adjacent cell with number from text answer

Name Values

Excel function question

Similar discussions

Subscribe To Our Newsletter!