Forum Discussion
Solved
Split a Sentence at a specific point using excel formula
I need an help to split a sentence using excel formula: For example see the below sentance 692 RUTLAND LLC 1,569.41 34 E 01820 182-183 I need only "692 RUTLAND LLC" alone from the above sent...
- A formula cannot be used unless there is a specific pattern for each string of your data.
Go to the cell and select this specific text, press CTRL-C, press ESC, go to the destination cell and press CTRL-V.