How can i move the building address number from the street name to a differant column. The file has thousands of entires.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Move address numbers into an other column
0
Answers
0
Selected Answer
Extract the number with this formula.
=LEFT($B2,FIND(" ",$B2)-1)Extract the remainder of the address, with the extracted number removed, with the formula below.
=TRIM(RIGHT($B2,LEN($B2)-FIND(" ",$B2)))Copy either formula down as far as needed. Working with thousands of rows look into Find & Select > GoTo where you can enter the address of the range to select in the Reference field.