| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Multiple formats for a single cell value.
I wish to use a formula or to format a cell value so as to only display
certain characters of the actual value. For example in the case of a value 123-45-6789, I would wish to only display 6789, or the last 4 digits. Is there a way that this is possible? |
|
#2
|
|||
|
|||
|
The formula is simple. Use
=right(a1,4) to get the last four characters of the cell. I don't know of a format which would do what you want, but maybe others will. -- Regards, Fred "Carlos" wrote in message ... I wish to use a formula or to format a cell value so as to only display certain characters of the actual value. For example in the case of a value 123-45-6789, I would wish to only display 6789, or the last 4 digits. Is there a way that this is possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to sum the values of a single cell from multiple worksheets | Excel Worksheet Functions | |||
| Multiple coin flips in a single cell | Excel Worksheet Functions | |||
| Maximum Number of Cell Formats | Excel Discussion (Misc queries) | |||
| multiple validation in a single cell | Excel Discussion (Misc queries) | |||
| Can vlookup return multiple matches in a single cell? | Excel Discussion (Misc queries) | |||
Linear Mode
