Query to get the specific information in a field

dhen21dx

Board Regular
Joined
May 10, 2013
Messages
166
Hi,

Can any body help me here how can i get some information in 1 field and i will make a new field. Example is below.

Subject Field
SystemX: NUM '0221929' Implement Task. Due Date: '2017-2-9 13:34:02'.Change Category:

Content Field


---------------------------------------
SystemX Production Message
Please take action
---------------------------------------


NUM 0221929,R71; CSP; addtional to NUM 0221041: added Option for G+F Flow has been promoted to Release sta

New Query
Field 1: value is 0221929
Field 2: value is 2017-2-9 13:34:02
Field 3: R71; CSP; addtional to NUM 0221041: added Option for G+F Flow
Field 4: R71

Hope you can help me.. The code seems to be challenging and i cant find a way from my side.

Thanks
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Forum statistics

Threads
1,221,771
Messages
6,161,847
Members
451,723
Latest member
Rachetsely

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top