Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to extract the first 3 digits from a cell (ex: AAG12345)?
I have 26,000 cells that I need to extract just the first 3 digits of the
cell. For example, the cell reads AAG122345 and I need a new cell that only reads "AAG". How can I do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to extract the first 3 digits from a cell (ex: AAG12345)?
Try this
With A1:A100 containing text entries and you want the 1st 3 characters extracted into a new list beginning in cell D1 Then Select A1:A100 From the Excel main menu <data<text to columns Check: Fixed Width............Click [next] Insert a break point after the 3rd character............Click [next] Select the 2nd column and Check: Do not import column Destination: D1 Click [Finish] That will copy the 1st 3 characters from A1:A100 into a new list beginning in cell D1 Does that help? Regards, Ron "Rob" wrote in message ... I have 26,000 cells that I need to extract just the first 3 digits of the cell. For example, the cell reads AAG122345 and I need a new cell that only reads "AAG". How can I do this? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to extract the first 3 digits from a cell (ex: AAG12345
Ron,
Perfect! Thanks for your help! Rob "Ron Coderre" wrote: Try this With A1:A100 containing text entries and you want the 1st 3 characters extracted into a new list beginning in cell D1 Then Select A1:A100 From the Excel main menu <data<text to columns Check: Fixed Width............Click [next] Insert a break point after the 3rd character............Click [next] Select the 2nd column and Check: Do not import column Destination: D1 Click [Finish] That will copy the 1st 3 characters from A1:A100 into a new list beginning in cell D1 Does that help? Regards, Ron "Rob" wrote in message ... I have 26,000 cells that I need to extract just the first 3 digits of the cell. For example, the cell reads AAG122345 and I need a new cell that only reads "AAG". How can I do this? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to extract the first 3 digits from a cell (ex: AAG12345)?
=LEFT(A1,3)
-- David Biddulph "Rob" wrote in message ... I have 26,000 cells that I need to extract just the first 3 digits of the cell. For example, the cell reads AAG122345 and I need a new cell that only reads "AAG". How can I do this? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to extract the first 3 digits from a cell (ex: AAG12345
I'm glad that worked for you......and thanks for the feedback!
*********** Regards, Ron XL2002, WinXP "Rob" wrote: Ron, Perfect! Thanks for your help! Rob "Ron Coderre" wrote: Try this With A1:A100 containing text entries and you want the 1st 3 characters extracted into a new list beginning in cell D1 Then Select A1:A100 From the Excel main menu <data<text to columns Check: Fixed Width............Click [next] Insert a break point after the 3rd character............Click [next] Select the 2nd column and Check: Do not import column Destination: D1 Click [Finish] That will copy the 1st 3 characters from A1:A100 into a new list beginning in cell D1 Does that help? Regards, Ron "Rob" wrote in message ... I have 26,000 cells that I need to extract just the first 3 digits of the cell. For example, the cell reads AAG122345 and I need a new cell that only reads "AAG". How can I do this? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to extract the first 3 digits from a cell (ex: AAG12345)?
Sat, 21 Apr 2007 07:48:01 -0700 from Rob
: I have 26,000 cells that I need to extract just the first 3 digits of the cell. For example, the cell reads AAG122345 and I need a new cell that only reads "AAG". How can I do this? Assuming those cells are in A1 through A26000, put this in B1: =left(A1,3) then click and drag that formula to the other 25999 cells in column B. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to extract the first 3 digits from a cell (ex: AAG12345)?
ASAP Utilities, a free add-in available at www.asap-utilities.com has a
feature that will delete all numeric characters from a string, leaving you with only the three alpha characters........... Vaya con Dios, Chuck, CABGx3 "Rob" wrote in message ... I have 26,000 cells that I need to extract just the first 3 digits of the cell. For example, the cell reads AAG122345 and I need a new cell that only reads "AAG". How can I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Type 3 digits in one cell then automatically move to next cell. | Excel Discussion (Misc queries) | |||
how do I extract hex digits in a cell and convert to binary | Excel Worksheet Functions | |||
Formula to extract digits from a text string? | Excel Worksheet Functions | |||
19 Digits in a Cell | Excel Discussion (Misc queries) | |||
12 or more digits in a cell | New Users to Excel |