Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting the last nine characters in a cell
Ok, I have three cells. In the first one (A2) there is an item and dollar amount:
XXXXXXXXXXXXXX ($10.00) In the second (B2) is a number: 1 The third (C2) is set up to populate if cell 2 has a number one in it with the following formula: =IF(LEFT(B2)="1",(IF(Left(A2,29)="XXXXXXXXX","XXXX XXXXX","")),"") This way it will see that there are ten Xs and then anything else and populate ten Xs in the cell. I need the formula of a vb code that will populate cell three (C2) with the information in cell one (A2) minus the last nine characters (" (10.00)"). TIA -Chris |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting the last nine characters in a cell
if you don't care to check anything
Sub MakeC2() Range("C2").Value = Left(Range("A2").Value,len(Range("A2").Value) - 9) End Sub -- Regards, Tom Ogilvy "Chris" wrote in message ... Ok, I have three cells. In the first one (A2) there is an item and dollar amount: XXXXXXXXXXXXXX ($10.00) In the second (B2) is a number: 1 The third (C2) is set up to populate if cell 2 has a number one in it with the following formula: =IF(LEFT(B2)="1",(IF(Left(A2,29)="XXXXXXXXX","XXXX XXXXX","")),"") This way it will see that there are ten Xs and then anything else and populate ten Xs in the cell. I need the formula of a vb code that will populate cell three (C2) with the information in cell one (A2) minus the last nine characters (" (10.00)"). TIA -Chris |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting the last nine characters in a cell
Use the Excel Help menu and Search for Find. The Help menu has some examples of using the Find function which needs to be incorporated into your IF() function.
-- Paul M "Chris" wrote: Ok, I have three cells. In the first one (A2) there is an item and dollar amount: XXXXXXXXXXXXXX ($10.00) In the second (B2) is a number: 1 The third (C2) is set up to populate if cell 2 has a number one in it with the following formula: =IF(LEFT(B2)="1",(IF(Left(A2,29)="XXXXXXXXX","XXXX XXXXX","")),"") This way it will see that there are ten Xs and then anything else and populate ten Xs in the cell. I need the formula of a vb code that will populate cell three (C2) with the information in cell one (A2) minus the last nine characters (" (10.00)"). TIA -Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting LF Characters in cells | Excel Worksheet Functions | |||
Deleting Characters | Excel Discussion (Misc queries) | |||
Deleting characters that are not numbers | Excel Discussion (Misc queries) | |||
limiting or deleting extra characters in a cell | Excel Discussion (Misc queries) | |||
Deleting Blank Characters in a Cell | Excel Discussion (Misc queries) |