00:00I always love great questions like this one here. How to extract negative number from string in
00:05Excel? In my past videos, I demonstrated how you can extract numbers with and without decimal
00:11using this formula. But if you have a negative number encapsulated in a string, you have to do
00:17some minor modification to our original formula. And here's how you can do it. We start off by
00:22using a let function to make the formula structure easier to be read. And then look for a negative
00:28character position in your string using a find function. If a negative character is found,
00:33we'll return a minus one else one is returned, which is stored in a variable a. After that,
00:40we extract the numeric value using the formula for my last video. Links to the previous videos
00:45are in my description. And then multiply the output from that formula with variable a. And then you're
00:52done.
Comments