How To Separate (Split) Text And Numbers In Excel With Go To Special Feature | Excel Tips & Tricks

preview_player
Показать описание
In this video, I will show you How to separate (split) text and numbers in Excel using Go To Special feature.

Steps on how to separate text and numbers in Excel using Go To Special feature

First, let's see - How to separate text in Excel
Step 1: Press CTRL + G on your keyboard. This will open Go To dialog box
Step 2: Click on Special
Step 3: Click on "Constants"
Step 4: Make sure checkbox "text" is selected only and deselect the rest
Step 5: Click on Ok

The selection changes to only selecting text.

Step 6: Copy these cells by pressing CTRL + C on your keyboard
Step 7: Select a destination cell with your mouse and paste by pressing CTRL + V on your keyboard

Like this, you can easily separate text in Excel

Now let's see, How to separate numbers in Excel
Step 1: Press CTRL + G on your keyboard. This will open Go To dialog box
Step 2: Click on Special
Step 3: Click on "Constants"
Step 4: Make sure checkbox "Numbers" is selected only and deselect the rest
Step 5: Click on Ok

The selection changes to only selecting numbers.

Step 6: Copy these cells by pressing CTRL + C on your keyboard
Step 7: Select a destination cell with your mouse and paste by pressing CTRL + V on your keyboard

Like this, you can easily separate numbers in Excel

Learn how to separate text and numbers in excel in Excel using the Go To Special feature in this Video.

If you have any questions on how to separate letter and numbers in Excel please drop your question in the comment box.

#excel #exceltips #exceltutorial #separatetext #separatenumbers #separatetextandnumbers
Рекомендации по теме