Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rob Rob is offline
external usenet poster
 
Posts: 718
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,118
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rob Rob is offline
external usenet poster
 
Posts: 718
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 698
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 524
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
Posts: 594
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Type 3 digits in one cell then automatically move to next cell. mulligbo Excel Discussion (Misc queries) 4 October 27th 06 11:51 PM
how do I extract hex digits in a cell and convert to binary prs_013 Excel Worksheet Functions 3 March 17th 06 08:14 AM
Formula to extract digits from a text string? [email protected] Excel Worksheet Functions 7 January 15th 06 05:16 AM
19 Digits in a Cell bri Excel Discussion (Misc queries) 1 November 30th 05 08:43 PM
12 or more digits in a cell scharlene New Users to Excel 4 August 30th 05 11:47 PM


All times are GMT +1. The time now is 12:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"