Excel - Separate Positive and Negative numbers in the same column

When you download data from a credit card company or bank, they frequently put positive and negative numbers in the same column. I like to have the numbers separated into two columns. You can achieve this in multiple ways. I'll use sorting, conditional formatting, and an IF Function. We will also use the COUNTIF function to determine how many negative and positive numbers we have. I'll also show Find and Replace (CTRL + H) to change the cell reference quickly.

Chapters:
0:00 Intro
0:55 Countif function
2:09 Sort the numbers
2:45 Go To to move around quickly
4:00 Conditional Formatting to select numbers
4:40 IF Function
6:00 Find and Replace

#msexcel #exceltraining #chrismenardtraining #microsoftexcel

And make sure you subscribe to my channel!

- EQUIPMENT USED --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!