You can use this as well...
=MID(C9,1,FIND("_",C9)-1)
Thanks
Rohan.
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick
Hi
Please use this :
=TRIM(LEFT(A1,FIND("_",A1,1)-1))
On Wed, Dec 7, 2011 at 4:00 PM, Raghunandan wrote:
> Hi All,
>
> Can someone help me out to extract number from string in Excel.
>
> Ex: 1_EB_AHR should write 1
> 456_EBF_RTY should write 456
> 1456_HGH_FG should write 1456
>
> Tha
=LOOKUP(99^99,--("0"&MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),ROW($1:$1
On Wed, Dec 7, 2011 at 2:30 PM, Raghunandan wrote:
> Hi All,
>
> Can someone help me out to extract number from string in Excel.
>
> Ex: 1_EB_AHR should write 1
> 456_EBF_RTY should write 456
>
