allredkj
New member
I'd like to extract the street number portion only for the address string and if none exists, I'd like it to return a '0'. An example of the data is below:
0005613Elliott Reeder Rd |
0007601Glenview Dr |
0007724Maplewood Ave |
0007348Boulevard 26 |
0006120Watauga Rd # C (this row is null) I'd like to see the following after the formula is applied: 5613 7601 7724 7348 6120 0 I appreciate your assistance!!! |