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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers in one column , need them cut into the next
Assuming Column A has your numbers:
A B C 2B14122 =LEFT(A1,4) =LEFT(A1,2) "InfoLisa" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers in one column , need them cut into the next
Assuming your data is in column A.......... In B1 put =LEFT(A1,2) This will get the first two characters In C1 put =LEFT(A1,4) This will get the first four characters In D1 put =RIGHT(A1,3) This will get the Right 3 characters....... Copy all three formulas down as far as you have data in column A Vaya con Dios, Chuck, CABGx3 "InfoLisa" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers in one column , need them cut into the next
=LEFT(A1,4)
This will take the first 4 characters starting from the left of the contents of cell A1. You can also use RIGHT and MID functions to get characters starting from the Right or Middle of a cell. HTH, Elkar "InfoLisa" wrote: 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers in one column , need them cut into the next
Info
=LEFT(A1,4) in B1 =LEFT(A1,2) in C1 Gord Dibben MS Excel MVP On 19 Jan 2006 11:43:18 -0800, "InfoLisa" wrote: 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. |
Reply |
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) |