Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Separate address column
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Gerry Kuta, post: 3443779"] I would appreciate help in splitting numbers from text in an address field. In A1 I have 3 or 4 numbers, a space, text, space, text... but the text portion can be variable. I would like to extract to Column B the number and to column C the text. Examples: 123 Anywhere St. 1234 Anywhere St 123 Anywhere 1234 Anywhere St. Is there a formula solution to this problem? TIA Gerry [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Separate address column
Top
