Extracting Data Part Two

P

PTori82

Board Regular
Joined
Dec 5, 2012
Messages
64
Hello again. I have a new question on extracting data; here are the two samples:

KCVS 141458Z 36013KT 1/2 BKN001 02/M11 A3020 RMK AO2 PRESRR SLP227 T00191110 52041 $</SPAN>

<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>


KCVS 141358Z 35012KT 10 CLR 00/M11 A3014 RMK AO2 SLP209 T00041112 $

</SPAN>

<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>
What I'm trying to do is take the bold underline values and place them in a separate cell (T6). If the value is 'BKN' of 'OVC' I need the following three numbers placed in T6. In this case, since I have BKN001, I need '001' placed in T6. If the value starts with 'CLR' 'FEW' or 'SCT' I need the value in T6 to read 'NONE". Thanks!
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Sort by date Sort by votes
PTori82,

This is a follow up from your last posted thread.

It would be easy to find a macro solution if you would supply a screenshot of the raw data, and, in that same screenshot, say in the next column to the right, what the results should be (manually formatted by you for the results you are looking for).


What should be in cell T7?


Excel 2007
ST
6KCVS 141458Z 36013KT 1/2 BKN001 02/M11 A3020 RMK AO2 PRESRR SLP227 T00191110 52041 $001
7KCVS 141358Z 35012KT 10 CLR 00/M11 A3014 RMK AO2 SLP209 T00041112 $
Sheet1
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Question
Extracting Data
2
Replies
10
Views
494
hiker95
H

Forum statistics

Threads
1,215,066
Messages
6,122,948
Members
449,095
Latest member
nmaske

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