Friday, September 03, 2004

Pick the first few characters in a cell : Excel Tip

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: