LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 29
Default calculating a sum from cells that contain letters and numbers

I continually evaluate data that comes in this form:

<"number" "text" ex. - < 0.3 U

I need a way to obtain the total while keeping the less than symbol and text
in the final result. Please note that the symbol and the text never changes
for a given data set. The data set tends to be upwards of 100 cells.

Any help will be greatly appreciated.

Thank you.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting Cells on letters and numbers and placing result in one of 3 columns pano Excel Worksheet Functions 2 February 7th 07 03:46 AM
Finding most common occurence of values in cells containing letters and numbers sparklyballs Excel Worksheet Functions 2 August 18th 06 12:16 PM
Sorting - cells containing numbers, numbers and letters Gunny Excel Discussion (Misc queries) 5 July 16th 06 01:22 AM
Finding Numbers with Cells that also contain letters Adam Excel Discussion (Misc queries) 7 December 29th 04 02:41 PM
How can I merge 2 cells with numbers and letters? fantasma Excel Worksheet Functions 12 December 7th 04 02:29 AM


All times are GMT +1. The time now is 09:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"