| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers in one column , need them cut into the next
Hi,
I have a worksheet that contains three seperate columns. In one column I have 7 numbers and letters combined. (i.e 2B14122) I want to move the first four digits into another column, and the first two digits into another column. How do I do that without copying, pasting and deleting? I'm sure there is a formula but I can't think of it. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Consecutive Numbers down a column not to Exceed 49 | Excel Worksheet Functions | |||
| column filtering to match identical numbers | Excel Discussion (Misc queries) | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| Average of numbers in column between to other numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
