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
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies