Remember Me?

#21
May 23rd 05, 06:13 PM
 CLR Posts: n/a

You're welcome Rodney, and if you're happy with that solution that Max gave
you, super-great!....if not, as with everything else in Excel, "there is
another way".

It uses Data TextToColumns Delimited hyphen as delimiter......and
conversion to Text on both columns, then using "ASAP Utilities" to strip off
all Letter-characters, then one simple formula copied down for the division
and to convert back to numbers....=IF(B10,A1/B1,A1)*1.....could probably all
be done with a macro, if you had to do it frequently

For me, it's easier.....

Vaya con Dios,
Chuck, CABGx3

"Rodney" wrote:

Thanks Domenic and CLR,
(40,000 rows) and have to take off for football umpiring.
Assistance appreciated
Rodney

--

"Rodney" wrote in message ...
|
| Here is what I hope to be a fair sample of some prices in a column,
| is anyone able to offer a formula to strip the text
| and convert to decimals please?
|
| 4-13F
| 2-5F
| 1-2F
| 8-13F
| 8-11F
| 4-5F
| 9-10F
| 1F
| 10-9F
| 5-4F
| 5-4
| 5-4F
| 11-8F
| 11-8EF
| 6-4F
| 13-8F
| 7-4F
| 7-4EF
| 7-4
| 15-8F
| 15-8
| 2F
| 10
| 250
| 300
|
|
|
|
|

#22
May 24th 05, 02:37 AM
 Rodney Posts: n/a

Roughly
latitude 30 06 South and longitude 116 38 East
(Perth, Western Australia)

(IIRC once voted the most boring city in Australia,
and.........I like it that way

I'll wave, next time I pass over on my way to Bkk

Rgds
Rodney

| You're welcome !
| Thanks for the feedback ..
|
| Btw ... 1° 22' N 103° 45' E = "Singapore" <g

#23
May 24th 05, 02:41 AM
 Rodney Posts: n/a

| You're welcome Rodney, and if you're happy with that solution that Max gave
| you, super-great!....if not, as with everything else in Excel, "there is
| another way".

Gee, Domenic,
I have already met with that.
I posted the solution against another offered on my Racing NG,
"Far Canal!"

In my usual Database NG, it was always a joy to see and
interpret different ways the spokes lead to the hub of a problem.

Best Regards
Rodney

#24
May 24th 05, 03:14 AM
 Max Posts: n/a

Thanks ! Looks like we're in the same time zone
I'll wave, next time I pass over on my way to Bkk

Just drop a note when you' re somewhere over 1° 22' N 103° 45' E,
and with some luck, it'll land within my reach <bg
--
Rgds
Max
xl 97
---
GMT+8,
xdemechanik <atyahoo<dotcom
----

#25
May 24th 05, 01:03 PM
 Domenic Posts: n/a

Rodney,

I'm not sure what you meant by "I have already met with that", but
Chuck, not me, posted the message below.

In article ,
"Rodney" wrote:

| You're welcome Rodney, and if you're happy with that solution that Max gave
| you, super-great!....if not, as with everything else in Excel, "there is
| another way".

Gee, Domenic,
I have already met with that.
I posted the solution against another offered on my Racing NG,
"Far Canal!"

In my usual Database NG, it was always a joy to see and
interpret different ways the spokes lead to the hub of a problem.

Best Regards
Rodney

#26
May 24th 05, 02:20 PM
 Rodney Posts: n/a

Oh?! sorry.
I'm one of those guys who harangues his wife for
hiding his glasses, when they're perched on top of my head all the time.
People who know me are used to it.

| Rodney,
| I'm not sure what you meant by "I have already met with that", but
| Chuck, not me, posted the message below.
|

#27
June 27th 05, 02:25 AM
 Max Posts: n/a

Here's a new link to the revised sample file
with the decomposed formulas in Sheet2:
http://www.savefile.com/files/9169505
File: 2_Rodney_newusers_Stripping_ConvertingData.xls
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

#28
June 27th 05, 02:49 AM
 Rodney Posts: n/a

Gee, I thought I may be enjoying deja-vu there Max
I'll have a dekko
Thanks.
Can "Save File" be used to post images?
I often need to post Postage Stamp Images on the web,
(short time usage) and wondered if this may suffice?

Cheers

"Max" wrote in message ...
| Here's a new link to the revised sample file
| with the decomposed formulas in Sheet2:
| http://www.savefile.com/files/9169505
| File: 2_Rodney_newusers_Stripping_ConvertingData.xls
| --
| Rgds
| Max
| xl 97
| ---
| GMT+8, 1° 22' N 103° 45' E
| xdemechanik <atyahoo<dotcom
| ----
|
|

#29
June 27th 05, 05:51 AM
 Max Posts: n/a

aha , you're still tracking this thread ? <bg
(the post was meant for the archives)

Can "Save File" be used to post images?

Probably so, but do check out the details/info on their home page ..
I just chanced upon the new site since discovering recently that the
previous file host (flypicture) appears to have removed all the sample files
posted, some a bit prematurely, it seems .. cheers.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

All times are GMT +1. The time now is 12:04 AM.