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 sentance. How can I achieve this using excel formula. Can anybody help me?
View best response
Go to the cell and select this specific text, press CTRL-C, press ESC, go to the destination cell and press CTRL-V.
Thanks@Twifoo for your immediate response. If I have any number at the end, then how can I extract the string? Like I asked in the question. Your help is much appreciated.
If for example, my strings are
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..
@Twifoo Thanks for the advise.. Thanks for your prompt reply..