Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2016

Tom has attended:
Excel Introduction course

Excel

I came across this symbol (~) the TILDE I think its called and I dont know it's purpose in the world of excel. Anyone?

RE: Excel

Hi Tom,

Thank you for your question. If you want to find or replace an asterisk (*), a question mark (?) or even a tilde (~) that is typed into any cell, you can type ~* or ~? or ~~ in the Find box of the Find tool. This will take you to the next cell where any of these symbols are found.

I hope this helps.

Kind regards
Marius Barnard

Wed 23 Dec 2020: Automatically marked as resolved.

Excel tip:

Select blank cells automatically

Get Excel to find any blank (empty) cells in a region for you by:

1. Selecting the appropriate region from your spreadsheet.

2. On the menu bar, go to Edit - Go to.

3. Click the 'Special' button, then select Blanks and click OK.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.