Can I take a NUMBER from a cell that also has text in it and sum it?

D

daviddschool

I made a survey but realised too late that I have A NUMBER ( like 2)
and TEXT in the same cell. I now want to SUM up the cell, but saw
that it doesn't work. Is there a way to format the cell or to just
take the number and add it ignoring the text?
 

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
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Cumulative formula for word table 0
Creating a Search using a combo box and then creating a report. 4
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Word macro that can call cells out of Excel for a find and replace 0
Cell data entering slow! 0
Custom Number sequences 0

Top