Large Data Base. The data was given to me in PDF and I converted using Adobe to Excel. The data have the address field as "Wrap Text".
Example: address above street name.
"12803
NORTHBOROUGH DR"
How do I get it to be ADDRESS IN ONE CELL COLUMN AND STREET NAME IN ANOTHER CELL COLUMN.
Some addresses have 3 numbers and others have as many as 5 numbers.
Windows 10, Excel 2016
Bookmarks