Venkat or Geo cum community person had an excel spread sheet, which had a time column, where in it had timings in minutes written like
10 minutes
5 min
25 minutes, etc.
8 m
like this he had hundreds of records, he didn't wanted the words minutes, min, m he just need the number values in a adjacent cell
Solution
=left(text,num_char)
using this formula we can pick up the first 2 characters in that cell which will be the numbers and get rid of the string.
No comments:
Post a Comment