Function, dont know what its called
I have the following example:
A 1 13 main st 2 37892 Oak st 3 8237 54th St I want to seperat the address from the street name in a seperate colum to end up with the following: A B 1 13 main st 2 7892 Oak st 3 48237 54th St Any help would be greatly appreciated. michael |
Function, dont know what its called
Assuming that the address always starts with the street number, followed
by a space, and then the street name, try... =LEFT(A1,FIND(" ",A1)-1) and =MID(A1,FIND(" ",A1)+1,1024) Hope this helps! In article , Michael wrote: I have the following example: A 1 13 main st 2 37892 Oak st 3 8237 54th St I want to seperat the address from the street name in a seperate colum to end up with the following: A B 1 13 main st 2 7892 Oak st 3 48237 54th St Any help would be greatly appreciated. michael |
All times are GMT +1. The time now is 03:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com