feature extraction - Extract numbers and decimal from string in EXCEL -
i have excel file contains 40,000 rows of data , trying create new columnn of number , decimal portion of strinng in column. tried trim() , left() number value size effects extraction. saw post in stov extracts numbers goal grab decimals can see exact value. here example of content of 1 cell. help!!!
abcd-ef (-320.94) ghi household collect agency
my desired outcome be: 320.94
or -320.94
with data in a1, use:
=mid(a1,find("(",a1)+1,find(")",a1)-find("(",a1)-1)
Comments
Post a Comment