Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy a function with a called cell constant? | Excel Worksheet Functions | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions |