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?
- expletive_xomLv 71 month agoFavourite 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.