extracting only integer values from a cell 1

[eHanSolo]

hi there,

i was wondering if there was a way to just extract integer values from a cell where it had both integer and string values like this:

3.44 mil

any sort of help would be greatly appreciated!!

e

 

[PHV]

Have a look at the Val function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[xlbo]

just to be sure - you don't think 3.44 is an integer do you ?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[eHanSolo]

cool. thanks for the tips.

3.44 is not an integer. 344 would be.
thanks!

 

[xlbo]

so do you want the integer only or the value of any numerals ?

for the latter you can use Val - for the former, you would need to use CInt

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[eHanSolo]

thanks geoff!