SOLVED
Home

Split a Sentence at a specific point using excel formula

kirupab390
New Contributor

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?

8 Replies

@kirupab390 

Go to the cell and select this specific text, press CTRL-C, press ESC, go to the destination cell and press CTRL-V.

 

If you want to extract the first 3 words in A1, the formula in B1 is:
=LEFT(A1,
FIND("|",
SUBSTITUTE(A1," ","|",3))-1)

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.

What do you mean by "any number at the end"?

HI@Twifoo 

 

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..

 

Solution
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..

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies