Thread: Return first 2 numbers of a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JBeaucaire[_96_] JBeaucaire[_96_] is offline
external usenet poster
  
Posts: 1
Default Return first 2 numbers of a cell

This should give you the first two characters in the cell.

=LEFT(A1,2)

If there are times the numbers are in a different position than that,
explain the differences and we'll adjust, but that's the basic answer.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=54916

Reply With QuoteReply With Quote