Forum Discussion
Excel spreadsheet creation
I have a spreadsheet that I am working with that has a lot of information already entered. I want to creat a new column that has the "house Number" only in this new column, and it is adjacent to the...
I notice that the house number is only the first 4 digits, if that apply to all, you can use this formula
C2= Address
=MID(C2,1,4)
see that attached file
- Jihad, I LIKE that formula! It works! Thank you!!!
- NOBINKJ, THANK YOU!!! That works too!! Thanks!!!!!!!!!!
