1
   

In Excel: seperating numbers to get only the first three

Forums: Computers
Email this Topic • Print this Page
 
 
kimberly
 
Reply Mon 5 Apr, 2004 08:33 am
I need to take the first three numbers of a five number sequence and send just those three to a seperate column in the same worksheet. Does anyone know if that is possible, and how to do it?

i.e. cell A1 says 36092 and I need cell B1 to contain 360

I would do it by hand but there are just way too many.

Thanks
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Discussion • Score: 1 • Views: 484 • Replies: 4
No top replies

 
the prince
 
  1  
Reply Mon 5 Apr, 2004 08:57 am
Formula for cell B1

=LEFT(A1,3)
0 Replies
 
roger
 
  1  
Reply Mon 5 Apr, 2004 10:37 am
Wow!
0 Replies
 
urs53
 
  1  
Reply Mon 5 Apr, 2004 10:40 am
You said it, Roger! Gautam, I am very impressed!
0 Replies
 
the prince
 
  1  
Reply Tue 6 Apr, 2004 01:08 am
Laughing <takes a bow>

Awwww - who pinched my butt ??? Twisted Evil
0 Replies
 
 

Related Topics

Super cool computer tricks, for dopes like me. - Discussion by OCCOM BILL
Clone of Micosoft Office - Question by Advocate
Do You Turn Off Your Computer at Night? - Discussion by Phoenix32890
The "Death" of the Computer Mouse - Discussion by Phoenix32890
Windows 10... - Discussion by Region Philbis
Surface Pro 3: What do you think? - Question by neologist
Windows 8 tips thread - Discussion by Wilso
Mac help/can't install new printer, don't remember passwd - Discussion by ossobuco
GOOGLE CHROME - Question by Setanta
.Net and Firefox... - Discussion by gungasnake
Hacking a computer and remote access - Discussion by trying2learn
 
  1. Forums
  2. » In Excel: seperating numbers to get only the first three
Copyright © 2025 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.12 seconds on 07/29/2025 at 11:17:51
▲ ▼