Amazing Flash Fill Feature In Excel 2013 - How It Works? (10 examples) - (Topic 1/2)

Finally, the preview version of MS Office 2013 is out. Obviously, we would be more interest in visiting our lovely MS Excel 2013 preview. You can download the MS Excel 2013 preview from here. See the snaps of MS Excel 2013 here.

Since I heard about Flash Fill feature in MS Excel 2013 much earlier, immediately after opens the Excel preview I first tested Flash Fill feature. After experienced the Flash Fill option performance in Excel 2013, I can simply say that the trailer is bumper hit !!! One scene of Flash Fill Option in the trailer is sufficient to make the movie super hit.

How To Extract Characters From Text String by Using LEFT Formula?

LEFT is one of the Most Useful Text Formula in MS Excel. LEFT returns the first character or characters in a text string, based on the number of characters you specify.


The Sytax for the LEFT function is
 =LEFT(text,[num_chars])