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.
HITwifoo
If for example, my strings are
692 RUTLAND LLC 1,569.41 34 E 01820 182-183
711 GAS INC DON 20,991.72 34 E 06980
I need to separate the 692 RUTLAND LLC & 711 GAS INC DON from the above strings..
Thanks in Advance..
A formula cannot be used unless there is a specific pattern for each string of your data.
Twifoo Thanks for the advise.. Thanks for your prompt reply..
- You're welcome!