| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Seperate text and numbers in a column?
On Wed, 10 Feb 2010 07:56:01 -0800, ????? (????) ????? <micky-a*at*tapuz.co.il
wrote: Wouldn't this - in B1 - be simpler and shorter ? =SUBSTITUTE(A1,C1," ") Micky Simpler, shorter, but not as robust. In the OP's example, the address number is always at the end of the string. Your solution fails if the address number happens to be included in the street name. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seperate Text and numbers in Post code | Excel Worksheet Functions | |||
| How can I seperate numbers from text (in one cell) into 2 cells? | Excel Discussion (Misc queries) | |||
| seperate first 2 lines of column in seperate columns in same row | Excel Discussion (Misc queries) | |||
| place text seperated by a space in a column into seperate columns | Excel Worksheet Functions | |||
| how do i seperate data from one column into two seperate ones in . | Excel Discussion (Misc queries) | |||
Hybrid Mode
