I have a copied spread sheet in my workbook that has names of businesses with numbers in the same column. The names of the businesses are not consistent in length.

example:

Copied sheet labeled "Jan" in Column A are the names of the business

Cell A1: Bob's Discount Sales -11024
Cell A2: Boardwalk Premier Center -33054
Cell A3: Capitol Premium Mega Center -44507
etc...

In sheet labeled "bus goals" in cell a1 I want to use =Jan!A1 but exclude the numbers in the business name.

Cell A1: =Jan!A1 (Include the text, but remove the numbers)
Cell A2: =Jan!A2 (Include the text, but remove the numbers)
Cell A3: =Jan!A3 (Include the text, but remove the numbers)
and so on.....