Anonymous asked in Computers & InternetSoftware · 1 month ago

How to add a cell after left function in excel?

I want to use the left function below to get the first letter of the cell B4 into C4 so I used =LEFT(B4,1), but I also want to add all the numbers in A4 afterwards so that cell C4 will show H008375. What formula can I use to achieve this?

Attachment image

1 Answer

  • 1 month ago
    Favorite Answer

    you would use either CONCATENATE() or the shorter &

    so your formula using & would be this

    =LEFT(B4,1)&A4i notice A4 has 008375 so you might get H8375 depending on how A4 is formatted.

    you might want to try something like this


    let me know how it works for you.

Still have questions? Get your answers by asking now.