Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Kristy
 
Posts: n/a
Default alphanumeric cells

Hello,

This might be a beginner question but is there any way to add alphanumeric
cells together? Example 30b+30b=60b? I am importing points from another
software package and need to total those points but retain the alpha value.

Thank you!
Kristy
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
do you always have only one character at the end of your data. and do
you also have different characters at the end and do you want to sum
them separately?

--
Regards
Frank Kabel
Frankfurt, Germany


Kristy wrote:
Hello,

This might be a beginner question but is there any way to add
alphanumeric cells together? Example 30b+30b=60b? I am importing
points from another software package and need to total those points
but retain the alpha value.

Thank you!
Kristy


Reply
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
Locate and delete specific cells David Smith Excel Discussion (Misc queries) 1 January 19th 05 05:45 PM
To safety merge cells without data destroyed, and smart unmerge! Kevin Excel Discussion (Misc queries) 0 December 30th 04 08:17 AM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 08:09 AM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:55 AM
Count number of shaded cells Maddoktor Excel Discussion (Misc queries) 2 December 20th 04 09:35 PM


All times are GMT +1. The time now is 06:54 AM.

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

About Us

"It's about Microsoft Excel"