Search : in
By :

Wild card functions for IF function in Excel

Last answer on Sep 7, 2009 7:13:44 am BST Peter, on Jul 25, 2009 3:21:30 pm BST 
 Report this message to moderators

Hello,

im writing in regards of how to formulate the IF function in excel to seperate out certain characters in a particular cell. For example if a series of cells says
15k
14k
13k
12k
11k
10k

and my objective is to sum up all the values, how do i seperate the "K" out of all these cells because the 'SUM' Function doesnt seem to work because of the letter "K".
Thanks heaps,
Peter

Configuration: Windows Vista Internet Explorer 7.0

Best answers for « Wild card functions for IF function in Excel » in :
IF Advance Function Show
EXCEL: The INTERSECTION function Show EXCEL: The INTERSECTION function You have a table consisting of rows and columns. Want to know the value of the cell at the intersection of a particular row / column in your table Example: Your table: - starts C3 to F3 ......
Excel – Arrow keys stopped functioning Show Excel – Arrow keys stopped functioning Issue Solution Note Issue I am using Excel 2000. I am trying to move from one cell to another in Excel by using the arrow keys on my keyboard but nothing happens. I was always able to move up,...
Colouring cells on conditions ShowColouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
Function Definition ShowThe Definition/Define Features on Google Google enables you to quickly find the definition of a word for this, do this: (Note: you must put a space before and after the colon (:), otherwise it will not work.) definition: Keyword...
[Excel 2003] - IF Function using Dates & Text Show[Excel 2003] - IF Function using Dates & Text Issue Solution Note Issue I'm trying to write a function for a cell which refers to a date in another cell - which if it is between 01/01/1994 and 31/12/1995 the cell will read U16, but...
Network cards ShowWhat is a network card? A network card (also called a Network Adapter or Network Interface Card, or NIC for short) acts as the interface between a computer and a network cable. The purpose of the network card is to prepare, send, and control data...
Management organizational chart ShowManagement organizational chart A project must be included in the general objectives of the business, because it generally mobilizes personnel for a long period of time. This is why it is necessary for an organization to determine its intentions in...
Spreadsheets - Mathematical Functions ShowStandard Functions Function Description ABS() This function returns the absolute value of a number. It therefore returns the number, if it is positive, or the opposite (positive) if it is negative ODD(value) Rounds a number up to the...
Ask your question Reply

1

venkat1926, on Jul 26, 2009 10:12:03 am BST

Suppose A1 down is

15k
14k
13k
12k
11k
10k


in B1 copy paste this formula
=LEFT(A1,LEN(A1)-1)+0
copy B1 down
add column B

I could have had formula
=left(A1,2)+0
but this will not work if your numbers are more than 2 digits, e.g. 122k

   
Reply to venkat1926

2

Peter, on Jul 26, 2009 11:27:49 am BST

Thanks heaps

   
Reply to Peter

3

 Stef, on Sep 7, 2009 7:13:44 am BST
  • +1

If the "k" is depicting 1000's, rather change the formatting in those cells to show the value in the formula bar as e.g. 15, but under cell formatting select Number, Custom and enter ####"k". This way the value of the cell is still numeric and thus calculable, but when printing or displaying it, it will show it as e.g. 15k.

   
Reply to Stef
Ask your question Reply
They need your help