| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Seperating Text from Numbers in a cell
Hi, Column C has a bunch of addresses that have no spaces between the
number and street. (27smith lane instead of 27 smith lane). Is there a way for me to quickly seperate the number and street name from the preceding number in each cell of column c? There are 1075 cells in column C. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel, seperating numbers and text, macro | Excel Discussion (Misc queries) | |||
| Seperating numbers from text | Excel Discussion (Misc queries) | |||
| Seperating text within a cell | Excel Discussion (Misc queries) | |||
| seperating text in one cell to multiple cells | Excel Discussion (Misc queries) | |||
| Seperating of Text in one cell into two columns | Excel Worksheet Functions | |||
Threaded Mode
