| Home > Forum Home > Developing Business Administration Solutions > Importing Data from PDF Files > Start and End text spaces | Share |
Start and End text spaces
Excel Help for Start And End Text Spaces in Developing Business Administration Solutions
| Forum Topic | Login |
Start And End Text Spaces | Rate this: (3/5 from 1 vote) |
 |
From the example given it is hard to know whether it work, but if the end text was simply '% ' then the the extraction should stop on the first number since the last % one would be at the end of the line and have no space after it. Otherwise, one could extract the first number from the output by using a LEFT(Cell,FIND(Cell," ")-1) formula. | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Start and End text spaces in the Excel Business Solutions Directory |