Text Split with Excel Formula – Example

August 28, 2011 at 2:47 pm Leave a comment

In one of the comments it has been asked as query about splitting some text from a string. In this post I am answering the query plus further extending it so that we can cover maximum use of Text Formulas Left, Right and Mid.

The query -

How to get Ch. No. 123456 from entire string like

Case 1 – ‘Ch.No. 123456 being the amt paid to party against bill no.256 dt. 12.07.2011′ or

Case 2 – ‘Mr. X given Ch.No. 123456 being the amt paid to party against bill no.256 dt. 12.07.2011′.

Entry filed under: Excel, Formula, MS EXCEL, MSEXCEL. Tags: Advanced, example, Excel, excel functions, Formula, help, MSEXCEL, rare, text formula, text separate, text split, tutorial.

How to get cube root or even further Shifted to

Leave a Reply Cancel reply

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Cancel

Connecting to %s

Trackback this post | Subscribe to the comments via RSS Feed

	Shelly on Excel Function – LA…
	pulse95 on Text Split with Excel Formula …
	Bhavesh on Text Split with Excel Formula …
	rshewade on Text Split with Excel Formula …
	deepak on Text Split with Excel Formula …

Learn Excel With Me