Data Parsing in Excel Using LEN and SUBSTITUTE function - HOT Tips
https://excel.tv/data-parsing-in-exce...
Oz shows an approach to parsing data in Excel using the LEN and SUBSTITUTE functions. This four srirachi tips leaves a smokey after-taste in your mouth. Oz discusses how parsing data is particularly important for small businesses who often have a lot of data in one cell and need an approach to separating out the data that they need without moving everything to columns.
Excel TV
SUBSCRIBE: / exceltvshow
Google Plus: https://plus.google.com/1165330821322...
Facebook: / exceltvseries
Twitter: / exceltv
LinkedIN: / excel-tv-7473731
Our Personal Sites:
Website
Rick Grantham: http://rickgrantham.com/
Jordan Goldmeier: http://optionexplicitvba.com
Oz Du Soleil: http://datascopic.net
Youtube:
Oz Du Soleil: / walruscandy
Rick Grantham; / mrrickgrantham
Facebook:
Rick Grantham: / authorrickgrantham
Jordan Goldmeier: / optionexplicitvba
Oz Du Soleil: / devilhorse
Google Plus:
Jordan Goldmeier: http://plus.google.com/+JordanGoldmeier
Rick Grantham: https://plus.google.com/+RickGrantham
LinkedIN:
Jordan Goldmeier: / jordangoldmeier
Oz Du Soleil: / ozdata
Rick Grantham: / rickgrantham
Twitter
Oz Du Soleil: / oz_dragoncookie
Rick Grantham: / bistrategyguy
Jordan Goldmeier: / option_explicit
Products:
Rick - Spreadsheet Templates for Small Business Owners - http://smallbusinesschampionbundle.com/
Jordan - Excel Consulting & Training
http://www.GoldmeierConsulting.com
http://www.ExcelAndAccess.com
http://www.VBAExpress.com