Anonymous
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

Relevance
  • 1 month ago
    Favourite 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

    =LEFT(B4,1)&TEXT(A4,"000000")

    let me know how it works for you.

Still have questions? Get answers by asking now.