If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
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, Have just downloaded the advice, have not tried it (40,000 rows) and have to take off for football umpiring. Shall return to report. Assistance appreciated Rodney -- (Remove gum to reply) "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
|
|||
|
|||
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 | How about you ? |
#23
|
|||
|
|||
| 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, and I got comments like "Far Canal!" "Holy Spreadsheet, Batman!" etc etc. 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
|
|||
|
|||
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 atyahoodotcom ---- |
#25
|
|||
|
|||
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, and I got comments like "Far Canal!" "Holy Spreadsheet, Batman!" etc etc. 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
|
|||
|
|||
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
|
|||
|
|||
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 atyahoodotcom ---- |
#28
|
|||
|
|||
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 atyahoodotcom | ---- | | |
#29
|
|||
|
|||
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 atyahoodotcom ---- |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
ASC save stripping characters | dennis | General Discussion | 2 | July 7th, 2004 12:22 AM |