How do I format a cell for user to enter in ft and inch

format such as 4'33". Then how do I multiply 2 cell

together to produce square foot. Example A1=4'33" and

B1=3'33" which is equal 14.42 Sq.Ft.

Thanks.

format such as 4'33". Then how do I multiply 2 cell

together to produce square foot. Example A1=4'33" and

B1=3'33" which is equal 14.42 Sq.Ft.

Thanks.

- Multiply cell with foot and inch
- Need to multiplicate foot and inches times a given number
- Multiplying one cell with another and getting a dollar amount
- Problem selecting cells with control and left click on mouse
- Formatting cells for feet and inches
- Macro to search for cells with text and then end loop
- Formula need to convert a cell with character and number
- Any tips on working with feet and inches in excel?
- How to input foot and inches and make it operational
- Multiply range with constant and round results
- Take cell with text and number and multiply with number
- Searching and replacing cells with corresponding value
- Manually update cells with formulas and macros
- Performing arithmetic functions to cells with number and text
- Matching data in multiple cell with Index and Match function
- Adding cells with numbers and cells with #NA
- How to find total and devide by the number of cells with data in them?
- Count coloured cells - But treat cells with colour and value as 0.5
- Macro to select cells with data and move them to another?
- IF statement based on two cells, with OR/AND
- Find all cells with Formulas and make bold
- Change cells with text and/or null to zero
- Formula to separate Cell with City and State with a comma and space in between
- Merge cells with Date and Time into "DATE TIME"

format such as 4'33". Then how do I multiply 2 cell

together to produce square foot. Example A1=4'33" and

B1=3'33" which is equal 14.42 Sq.Ft.

Thanks.

Gabo

Example:

$0.07 (Cell A)

X's

200 (Cell B)

Total $ (Cell C)

Thank you so much for any help with this!

I want to select several cells and I am using the control key and left mouse button to select the cells but when I copy them it does all of the cells between what is selected and the selected cells also. the same way it would do if I were to select two cells and use the shift key and left mouse button. there is no difference between the two. with the control key I should only be getting the cells I selected. any thoughts. I can copy them to another excel page and all works fine but not when I go to notepad. I could copy them to another excel page and then reselect them to notepad but I want todo it in one step.

thanks

For example, if I type 6.738 in a cell, I want it to display 6'-8 7/8".

I know how to use the lentext() and feet() modules, but they are not cell formats.

Any ideas?

However, after several rows of numerical data, there is a row of text to separate different test cases.

I want to code a "do until" loop that will look at each cell in column A. I want to include an "if then else" statement that will end the "do until" loop when it reaches a cell with text and then select that same cell with the text. I want it to stop when it reaches a cell with text period. Not just for a specific word or something. I'm not trying to delete the cells with text or anything either. I'm just trying to figure out how to write the "condition" for the "if then else" statement right now.

I would like to know if there is any formula I can use to convert a cell with character and number?

e.g. 1.5D2 --> D

4C --> C

A2.0 --> A

Any help will be appreciated.

The problem is that if I'm working with imperial measure, I have to convert

to metric then covert back to imperial. Is there any ways to easily work with

feet and inches that i'm not seeing?

how do i make excel to recognize them as numbers?

what formula can help me in multipy foot and inches times full numbers. I hope you can save me again. Thank you very much mis amigos.

For example,

A1:A30 is the range

Constant is found in A33

All cell in the range will be multiplied with A33 and the result should be rounded (it will be an int number). The result will overwrite the initial cell.

Thanks for the help

F8 = ND (0.005)

N8 = 0.0012

I need to extract the number, "0.005" in F8 which is in text format and multiply it with the number, "0.0012" in N8 and output this in AD8. How do I do this, without changing the format of F8?

I need this urgently, please help!

Thx,

Sami

I am trying to find a way to search through a column of data, and replace the cells with a predefined value. ie There are cells with ABC, and I want to replace it with 123. I want to replace each cell with a predefined value, and it appears many times over in the column of data.

So for example:

A B C

HOU@PHI Houston Texans Philadelpia Eagles

MIA@NYG Miami Dolphins New York Giants

Where I want HOU to be replaced with Houston Texans, and placed into column B. Then PHI to be replaced with Philadelphia Eagles in Column C. I want to change each abbreviated name and move it to another column etc...

Thanks so much, this is doing my head in!!!

Kamila

I cant figure out why I must update all cells, with formulas, manually after I do something with the workbook. I'll try to make an example.

If I make a macro that enters =sum("F1:F10") it says #NAME? when its done, but if I dubbleclick it and press enter it calculates the cell like its supposed to. I've tried to press alt + ctrl + F9, but that doesnt work.

Is there a command to dubbelclick the entire workbook and then press enter if you know what I mean?

This is really annoying, does anyone have any suggestions?

Thanks

Erik

and I would like to find the difference of that cell with one of similar

format...75/57

by subtracting 75-80 and 57-60.

How can I do this with the / embedded within the cell.

Perhaps just entering the data with a "," instead would help?

can anybody help me on this?

I want to select value in Column A3, B3 and C3 and then give a date in Column D3 in order to get the result to be shown in cell E3 to H3. The rates should match all data including the date and then show the desired result. Is it possible with Index and Match formula. I may have a lot of entries in the Data and Rate sheet. Is my layout in Rate Sheet correct or do I need to change this?

The excel sheet attached for reference.

Thanks for helping

Paltun

CellA CellB cellC CellD

Sometimes CellB wont have any data and therefore CellC also wont have data so the value of CellD (the average) would be CellA.

Sometimes though CellC wont have data but CellA and CellB will so the average would be (CellA+CellB/2)

This is the formula I have so far which will give a value when CellA has data only and it will give a value when both CellA and CellB have data:

IF(ISNA(B1),A1,(A1+B1)/2)

How do I then get it to average out the data when all three cells have data?

I have a spreadsheet and a module that allows me to count coloured cells.

If the cell with a colour in has ANY text in it, then I need it to count it as 0.5 instead of 1.

Any ideas?

Current Code:

Function ColorFunction(rColor As Range, rRange As Range, Optional SUM As Boolean) Dim rCell As Range Dim lCol As Long Dim vResult '''''''''''''''''''''''''''''''''''''' 'Written by Ozgrid Business Applications 'www.ozgrid.com 'Sums or counts cells based on a specified fill color. ''''''''''''''''''''''''''''''''''''''' lCol = rColor.Interior.ColorIndex If SUM = True Then For Each rCell In rRange If rCell.Interior.ColorIndex = lCol Then vResult = WorksheetFunction.SUM(rCell, vResult) End If Next rCell Else For Each rCell In rRange If rCell.Interior.ColorIndex = lCol Then vResult = 1 + vResult End If Next rCell End If ColorFunction = vResult End FunctionCheers

I'm finally admitting defeat with this one after spending hours searching and attempting to build.

I need a macro that will do the following can anyone help?

1) Select only cells within a specific column that contain an entry

(The specific columns are C H M R W AB AG AL)

Then

2) With only those cells with data selected I want excel to then include in that selection the 2 cells to the left of the original selected cell and the 1 cell to the right.

Then

3) I need to move that data to the first available cell in column AT.

Then

4) Go back to where the original data was and shift those four empty cells up with out deleting the row

Many thanks to anyone who can help.

Best Regards,

Gav

This is really getting on my nerves. I have two cells with the following choices:

T7

Risk Level:

High

Med

Low

Nominal

W7

Annual Spend Range:

<$200K

$200K-$500K

$500K-$2m

>$2m

What I want is a simple formula which does the following:

If

(Cell T7 = Nominal or Low)

AND

(Cell W7 = <$200K or $200-$500)

THEN “No”

ELSE “Yes”

It keeps giving me a #value error!!

Thanks in advance!!

John

Any help is appreciated

Thanks

Charles

Thanks in advance for your help. It's much appriciated!

in A1: Philadelphia, PA

in A2: New York, NY

I need to be able to separate this into two cell, with city in one cell and state in the other.

1) For the the state, I know that I can do right(a1,2) and this works;

2) Can you separate the city, which would be to the left of the comma? I am struggling since the city in each of the cells are different lengths.

I appreciate your guidance!

Thank you!!

I have read alot about merging cells. But I haven't seen any string about merging cells with diffrent formats.

I have a spreadsheet which contains one column with Date (2006-12-01) and one column with Time (12:30:00) and I want to merge it into one cell so it would be 2006-12-01 12:30:00. The reason is so that I later on can count the networking hours between 2 DATE/TIME cells.

Thanks in advance!