Simple Data Extractiom

[richardthelionheart]

<colgroup><col style="mso-width-source:userset;mso-width-alt:8338;width:171pt" width="228"> </colgroup><tbody>
[TD="class: xl63, width: 228"]Dark Aero Form: 31
[/TD]

[TD="class: xl63"]Alien Loren Form: TTTTT[/TD]

[TD="class: xl63"]Cairns Lulu Form: T3166[/TD]

[TD="class: xl63"]Shellam Larry Form: 415
[/TD]

[TD="class: xl63"]Madabout Molly Form: 55161[/TD]

[TD="class: xl63"]Cashen Flo Form: 3316T

Let's say this data is in column A rows 1 - 6
In column B rows 1 - 6 I want to see -
Form: 31
Form: TTTTT
Form: T3166
Form: 415
Form: 55161
Form: 3316T

So ............
the only ' constant' is Form: (which I want to retain)
I'm sure this is fairly simple but I could take hours figuring out ' ' search, ' find " ???
Any help greatly appreciated.

[/TD]

</tbody>

 

[JackDanIce]

Try:

=TRIM(MID(A1,FIND("Form:",A1)+5,LEN(C2)))

 

[richardthelionheart]

Try:

=TRIM(MID(A1,FIND("Form:",A1)+5,LEN(C2)))

Thanks, Jack it works well. (Hope the London weather is not too miserable right now)

 

[JackDanIce]

You're welcome and thank you, actually a bright sunny day today! Though I'm sure warmer for you right now

 

[Peter_SSs]

Thanks, Jack it works well.

Really? What does LEN(C2) have to do with data in A1:A6?
Also, you said you wanted to retain "Form:". The given formula does not do that.

In column B rows 1 - 6 I want to see -
Form: 31
Form: TTTTT
Form: T3166
Form: 415
Form: 55161
Form: 3316T

My suggestion is shown in B1 (copied down). For comparison, I have included the previously suggested formula in D1 (copied down). The column is blank!

Excel Workbook
	A	B	C	D
1	Dark Aero Form: 31	Form: 31
2	Alien Loren Form: TTTTT	Form: TTTTT
3	Cairns Lulu Form: T3166	Form: T3166
4	Shellam Larry Form: 415	Form: 415
5	Madabout Molly Form: 55161	Form: 55161
6	Cashen Flo Form: 3316T	Form: 3316T
Form

 

[richardthelionheart]

Well, Peter, you are in fact right. But then you are a moderator so that would be expected I guess. I chose to go down the 'diplomatic path' as it were, and with a bit of tweeking I made the formula work. (ie the original one). I fully understand that in the world of mathematics and excel formulas things are either right or wrong. I realised that the Form: component had disappeared in the original formula and decided, on reflection, that I could just insert a new column with Form: and the adjacent column with the numbers and digits. I also understand that your post was just you doing your 'job' it I can put it that way. Thank you.

 

[Peter_SSs]

No problem. My comments were as much for other future readers (who might not be able to make the required 'tweaks') as for you. Anyway, you now have choices.