Forum Discussion

sameer khan's avatar
sameer khan
Copper Contributor
Aug 26, 2018

I want to know

I want to know to mix up both cell into sigle cell with middle line symbols
Excel Online
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Aug 26, 2018

    Hi Sameer,

     

    I think you mean the Merge & Center functionality in Excel?

    If so, please read this article to learn how to use it.

     

  • vijaykumar shetye's avatar
    vijaykumar shetye
    Brass Contributor
    Aug 26, 2018

    Hi sameer khan,

    If A1 and C1 are the cell that you want to join (mix) and cell B1 is the middle line that contains the symbol, then use the formula

    =A1&B1&C1 

     

    If you want to introduce spaces between the content of different cells, the use the following formula

    =A1&" "&B1&" "&C1

     

    Do let us know if this is what you wanted to do, or if you require any changes.

     

    Vijaykumar Shetye,

    Panaji, Goa, India

Resources