Grouping/Sorting all cells that contain letters and numbers?

[AKM1]

I have a worksheet in which there are cells with text, as well as some cells that start with text but include a number somewhere within the cell (either between or after the text).

Is there any way to easily identify and group these cells together for easier sorting?

[xLJer]

Let's say your values are in column A starting at row #1.
In a new column type:

Please Login or Register  to view this content.

Copy the formula down to the end of your data.

Now use that new column as a primary sorting field and all your
rows with a non-numeric value in column A will appear at the top.

[AKM1]

I may not have explained myself properly. Some cells contain text and numbers mixed. For example ABC123 may be a value in a cell. So what I need to do is try to identify any cells that contain a number (even if the value begins with a letter).

[xLJer]

This formula solution was given by Ron Coderre in 2009 in this forum.
It displays TRUE if the string contains a number, otherwise FALSE.

Please Login or Register  to view this content.