Can't get excel to recognize numbers and not text in a cell

TylerGraham

New Member
Joined
Dec 4, 2014
Messages
4
It is probably a simple answer that i just have not been able to see.

I have converted everything in my spread sheet to inches, then did the formula to find square ft. - No Problems there

What i need to do is " lets say A1 = 66 and A2 = 66 The Sq. Ft. it gives me is A3 = 30.25. I need to specify what the measurements are for. So instead of A1 = 66, I want it to say A1 = 66 Long and A2 = 66 Wide.

The problem is when i add text into the cell it gives me a value error.

Is it possible to have "66 long" in a cell and have excel only recognize the "66" and not the "long" for formula purposes?

I am somewhat new to this. I imagine its simple, but the solution is evading me.

Thanks,
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

skywriter

Well-known Member
Joined
Feb 15, 2014
Messages
1,642
Type 66 in your cell then go to format cells, I have Excel 2010 and if I right click on a cell it comes up on the context menu, or I can hit control + 1.

Choose custom and under the word "Type" enter the following 0 "long", above this where it is says sample you will see that your cell is going to show 66 long. The underlying number in the cell is still just 66 and you can do whatever math you want to with it.
 

ghrain22

Active Member
Joined
Jan 9, 2014
Messages
473
=LEFT(A1,SEARCH(" ",A1)-1) would strip out everything after the space.
 

TylerGraham

New Member
Joined
Dec 4, 2014
Messages
4
Skywriter, That's exactly what i was looking for. I just might make it home from work on time.

Thanks,
 

Watch MrExcel Video

Forum statistics

Threads
1,122,889
Messages
5,598,672
Members
414,254
Latest member
MarieCo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top