I have an excel spreadsheet which has names and addresses in it. They are listed as
first name last name 12344 Street name Street Type
I am trying to break this down and put each in it's own column in Excel so I can join it with my attribute table of a hosted feature layer in ArcGIS Pro.
Can anyone help me with the Excel function which would accomplish this?
Note: I figured out how to get the name from the Excel cells but having trouble with the address number which is the middle of the string.