Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-13-2016, 01:34 AM
Fean Fean is offline Right find Windows 7 32bit Right find Office 2010 32bit
Novice
Right find
 
Join Date: Apr 2016
Posts: 5
Fean is on a distinguished road
Default Right find

Hi i have difficulties with Right and Find.



In a cell A1 to A20 i have;
A1 Am 0.xlsm

In cell B1 I want only the 0 or 1 from the above.

Of course i can do =RIGHT(C7,6)
but that gives me "0.xlsm"

I want only the 0 or 1 or what stands before the "."

Something like this (but that only goes well till B2
=RIGHT(FIND(".",A1,6)-1)
Reply With Quote
  #2  
Old 04-13-2016, 03:33 AM
Fean Fean is offline Right find Windows 7 32bit Right find Office 2010 32bit
Novice
Right find
 
Join Date: Apr 2016
Posts: 5
Fean is on a distinguished road
Default

Found out myself..
=LEFT(RIGHT(C7,6),1)
Reply With Quote
  #3  
Old 04-13-2016, 08:34 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Right find Windows 7 64bit Right find Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Cross post without links http://www.excelguru.ca/forums/showt...ed=1#post23610

Read http://www.excelguru.ca/content.php?184
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
find IP in range / find number between numbers gn28 Excel 4 06-14-2015 03:46 PM
Right find Find where find text contains a double quote norgro Word VBA 1 01-23-2015 10:58 PM
Right find Find what box in Find and replace limits the length of a search term Hoxton118 Word VBA 7 06-10-2014 05:05 AM
Right find Macro that can find phrase and then find another and copy jperez84 Word VBA 10 09-19-2012 04:48 PM
Right find Bad view when using Find and Find & Replace - Word places found string on top line paulkaye Word 4 12-06-2011 11:05 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:28 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft