how to add and merge two value in one column MS Excel

Description

If you can remove first text or character with ysed merge two cell text

Combine text from two or more cells into one cell 

How to merge two columns data into a third column.

Combine Cell Data in Excel. How to Merge Cells in Excel

combine multiple columns in excel into one column

combine text from two or more cells into one cell

excel combine multiple cells into one separated by comma

excel combine columns into one list

 

If you can remove first text or character with ysed merge two cell text

 

 

like 

 

09890 

 

Now yor are remove only 0 value so

follow these Step

 

 

C1&""&A1 and than enter

 

copy cell and past in another cell

on right click and select paste spacieal

and  select values format

now select cell and Ctrl+f

Find and replace first two word.

 

Note

 

first write ant sigle word in cell

and next cell wriet =cellname (select onclick word)

A1 merge cell select (onclick word)

and enter