This post details the step by step to retrieve data selectively from cells
Assuming you have a spreadsheet below and you want to retrieve Normal1, Normal2 and Normal3 into another colum, say B.
You can use the LEN function in Excel to manipulating text in Excel
Select Colum B2 and enter =RIGHT(A2,LEN(A2)-10) where A2 is the colum that hold the data to be manipulated. the number 10 is the number of letter from J to the hypen infort of Normal, J being 1 and _ 10
Latest posts by Emmanuel (see all)
- How to Enable Failed Tracking Request in IIS7.0/8.5 - February 18, 2016
- Switching from Local account to Microsoft account in Windows 10. - October 26, 2015
- How to export a certificate with the private key - October 8, 2015