A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Stripping and Conversion.



 
 
Thread Tools Display Modes
  #21  
Old May 23rd, 2005, 06:13 PM
CLR
external usenet poster
 
Posts: n/a
Default

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  
Old May 24th, 2005, 02:37 AM
Rodney
external usenet poster
 
Posts: n/a
Default

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  
Old May 24th, 2005, 02:41 AM
Rodney
external usenet poster
 
Posts: n/a
Default

| 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  
Old May 24th, 2005, 03:14 AM
Max
external usenet poster
 
Posts: n/a
Default

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  
Old May 24th, 2005, 01:03 PM
Domenic
external usenet poster
 
Posts: n/a
Default

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  
Old May 24th, 2005, 02:20 PM
Rodney
external usenet poster
 
Posts: n/a
Default

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  
Old June 27th, 2005, 02:25 AM
Max
external usenet poster
 
Posts: n/a
Default

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  
Old June 27th, 2005, 02:49 AM
Rodney
external usenet poster
 
Posts: n/a
Default

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  
Old June 27th, 2005, 05:51 AM
Max
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ASC save stripping characters dennis General Discussion 2 July 7th, 2004 12:22 AM


All times are GMT +1. The time now is 09:08 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.