Add a column of numbers with text in each cell?

J

Jim

I have a column of numbers in a worksheet that has a number as well as some
text in each cell. I want to add all of the numerical values, and ignore the
text. How do I accomplish this?
Thanks!
Jimbo
 
D

Dave R.

Can you give an example of what these things look like? Are the numbers
always the same length?
 
G

Gord Dibben

Jim

Is the data consistent?

i.e. abcd1234 or 1234abcd

Show us an example and there probably is a method you can use with a helper
column to break out the numbers.

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Cell data entering slow! 0
How can the font and size of (all) citation numbers be altered? 1
Finding the proper style field and the numbered paragraph value within the style 0
Autonumber field in Excel that behaves the same as Access 0
Finding the right style field in VBA 0
Page numbering with Merged Document and IF statements 1
Macro to select and delete levels of a document 2

Top