Strings...extracting and altering data...

How_Do_I

How_Do_I

Well-known Member
Joined
Oct 23, 2009
Messages
1,831
Office Version
  1. 2010
Platform
  1. Windows
Can anyone help me with the following please... My expected results are highlighted... I would look at some youtube videos but my connection is on snail pace and I can't watch videos at the moment...

Excel Workbook
HIJKL
1417.03.200617-Mar-06Date
15( 0-0 )00Score to 2 Columns
161-010Score to 2 Columns
17( 0-0 )0 - 0Score to Single Column
181-01 - 0Score to Single Column
Sheet3
 
Sort by date Sort by votes
Sandeep… Thank you very much for that, needless to say, it all works brilliantly…
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p> </o:p>
I must admit that you are another one of the people who I follow on this site, as you provide excellent solutions and I like the way you use the Jeanie to give your solution…
<o:p> </o:p>
Thanks again… :)
 
Upvote 0

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
You must log in or register to reply here.

Similar threads

A
  • Question
Macro for extracting selected text and comment from Word to Excel on Mac
Replies
4
Views
190
aminchicago
A
N
  • Solved
Formula to change font color in part of cell only
Replies
2
Views
383
Nathan Asius
N
R
  • Question
Help with Macros
Replies
1
Views
325
t0ny84
T
Y
  • Question
Extract some (not all) numbers from these strings
2
Replies
12
Views
590
Dan_W
D
E
  • Question
Extract text under a string from EML files
Replies
0
Views
92
excelknuckles
E

Forum statistics

Threads
1,215,693
Messages
6,126,248
Members
449,304
Latest member
hagia_sofia

Share this page

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