Tuesday, October 14, 2008

Places To For Dinner Bangalore Anniversary

an example conditional formats with = MID


This is the case for identifying items with strings of numbers and letters that make sense to us.
= MID (A2, 4, 3) take what is in cell A2, it has 4 characters (the first argument of the function) and extract that character and 2 below (which adds 3, the second argument of the function .)
If we extract the final numbers would have to have 8 places to the first value and 6 until the last from this value: = MID (A2, 8, 6)

0 comments:

Post a Comment