| Home > Forum Home > Automating Data Analysis Tasks > Separating text from numbers > Get the space character | Share |
Get the space character
Excel Help for Get The Space Character in Automating Data Analysis Tasks
| Forum Topic | Login |
Get The Space Character | Rate this: (3/5 from 1 vote) |
 | If each cell is always text then space then number, you can get the text using a LEFT function and FIND function on the space. Assume your text is in cell B3, the formula would be =LEFT(B3,FIND(" ",B3)) | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Get the space character in the Excel Business Solutions Directory |