| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Letter/Number Split
Hi everyone, Im currently making a database by copying fields from another database, and I have some problems with separating numbers and letters. An example of what im trying to do is- Trying to split UNIT 7 5-9 WOON GARDENS 24 RYDER ROAD 6 JESTER COURT 11 GRADER ROAD 4 ALEN PLACE 7 WILENSON LANE UNIT 1 FAR ROAD SHOP 771 CANTON HWY So there are 2 different cells. One containing the writing upto and including the last number, and one with the remaining. For example Column A UNIT 7 5-9 24 6 11 4 7 UNIT 1 SHOP 771 Column B WOON GARDENS RYDER ROAD JESTER COURT GRADER ROAD ALEN PLACE WILENSON LANE FAR ROAD CANTON HWY Is this actually possible? I tried text to columns, but that didn't really work too well. Any Ideas? Thanks, Andrew -- carlito_1985 ------------------------------------------------------------------------ carlito_1985's Profile: http://www.excelforum.com/member.php...o&userid=21390 View this thread: http://www.excelforum.com/showthread...hreadid=379592 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I split the y-axis scale on a chart? | Charts and Charting in Excel | |||
| How do I split a single cell in Excel ? | Excel Discussion (Misc queries) | |||
| split a single column into 2 separate columns | Excel Worksheet Functions | |||
| Split combined date time data | Excel Discussion (Misc queries) | |||
| Split combined date time data | Excel Discussion (Misc queries) | |||
Threaded Mode
