Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I display heights (6' 2") in Excel columns?
I'm trying to copy-and-paste a football roster into Excel. The roster lists
the heights & weights of the players. When I paste into Excel, heights (ex 6' 2") do not transfer; instead, only a list of numbers appears. I've tried several different formats for cell numbers with no luck. Can anyone help? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I display heights (6' 2") in Excel columns?
If the data is actually numbers, you could try a custom format:
#' 00'' (note the last characters are two apostrophes, not a quotation mark) If text (maybe your data has a space in it), you could try =TEXT(TRIM(A1),"#' 00''") (last 3 characters are two apostrophes followed by a quote) There is an assumption that your data does not have extra characters that look like spaces (you could do a search/replace for spaces and/or the character generated by Alt-0160) and will be 3 numbers, not mixed such as 5 10 5 4 If it is mixed, you could try =LEFT(A1)&"' "&IF(LEN(TRIM(A1))1, TEXT(RIGHT(TRIM(A1),LEN(TRIM(A1))-1), "00"), "00")&"''" "Chopdawg" wrote: I'm trying to copy-and-paste a football roster into Excel. The roster lists the heights & weights of the players. When I paste into Excel, heights (ex 6' 2") do not transfer; instead, only a list of numbers appears. I've tried several different formats for cell numbers with no luck. Can anyone help? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel should show Comment box even if adjacent columns are hidden | Excel Discussion (Misc queries) | |||
Can I add more columns in Excel past column IV | Excel Discussion (Misc queries) | |||
Open an excel file but it does not display | Excel Discussion (Misc queries) | |||
Sorting Columns on HTML file created in Excel | Excel Discussion (Misc queries) | |||
Linking Excel columns in two different excel programs | Excel Discussion (Misc queries) |