Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Separate numbers from words

Status
Not open for further replies.
Jackxxx

Jackxxx

Programmer
Jun 21, 2007
31
US
I have been given a table with a column that should have only been numbers, but people have been entering words too. So I need to move the ones with alph characters to a new column.

How can I do this?

Thank you,
 
Sort by date Sort by votes
How about [blue]=if(isnumber(A1),A1,"")[/blue] in one column and
[blue]=if(istext(A1),A1,"")[/blue] in another.


Randy
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

PrimoSteve
  • Locked
  • Question
Grid From 1
2
Replies
21
Views
1K
PrimoSteve
PrimoSteve
caykamanj1966
  • Locked
  • Question
Available Numbers
Replies
1
Views
107
dhookom
dhookom
PrimoSteve
  • Locked
  • Question
Fill in 2nd Textbox2 from Textbox1
Replies
3
Views
265
PrimoSteve
PrimoSteve
TomSalvato
  • Locked
  • Question
Getting the Monday date from a week number 1
Replies
2
Views
309
TomSalvato
TomSalvato
TrekBiker
  • Locked
  • Question
Running query with parameter from Inputbox 2
Replies
8
Views
321
TrekBiker
TrekBiker

Part and Inventory Search

Sponsor

Back
Top