![]() |
#1
|
|||
|
|||
![]()
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) |
#2
|
|||
|
|||
![]()
Found out myself..
=LEFT(RIGHT(C7,6),1) |
#3
|
||||
|
||||
![]()
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 |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
find IP in range / find number between numbers | gn28 | Excel | 4 | 06-14-2015 03:46 PM |
![]() |
norgro | Word VBA | 1 | 01-23-2015 10:58 PM |
![]() |
Hoxton118 | Word VBA | 7 | 06-10-2014 05:05 AM |
![]() |
jperez84 | Word VBA | 10 | 09-19-2012 04:48 PM |
![]() |
paulkaye | Word | 4 | 12-06-2011 11:05 PM |