NikkiMc204
New Member
- Joined
- May 24, 2021
- Messages
- 23
- Office Version
- 365
- 2016
- 2013
- Platform
- Windows
Hi can some kind soul help me with a calculation error I'm getting
I'm trying to extract the first numerical value from a text string. The text "10 FTE X 1hr = X days"
So i'm trying to extract the first number "10" I don't want any of the other numbers that show after the text FTE.
I've used this formula =(IFERROR(LEFT(H4,(FIND("FTE",H4,1)-1)),"")) which extracts the number 10 fine but when I go to add up all the figures using this formula i get a zero value =sum(h4:h500)
Where am i going wrong?
I'm trying to extract the first numerical value from a text string. The text "10 FTE X 1hr = X days"
So i'm trying to extract the first number "10" I don't want any of the other numbers that show after the text FTE.
I've used this formula =(IFERROR(LEFT(H4,(FIND("FTE",H4,1)-1)),"")) which extracts the number 10 fine but when I go to add up all the figures using this formula i get a zero value =sum(h4:h500)
Where am i going wrong?