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

cells

ResolvedVersion 2007

Jervis has attended:
Excel Intermediate course
Excel Intermediate course

Cells

What is the best way to delete numbers in a group of adjacent cells

RE: Cells

Hi Jervis

Thanks for your question

Can you clarify your needs for me?

Do you wish to select a range of cells and delete the data from any cell that contains numbers, leaving cells with text undeleted?

Thanks

Stephen

Excel tip:

Enter formulae into multiple cells

If a formula is to be used in a series of cells, select the cells first. Now type in your formula and hold the Ctrl key while you press Enter. This enters the formula in each selected cell.

Just be careful with your absolute and relative cell references.

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.11 secs.