Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Extra Character in cell
I have a very large spreadsheet that two of the colums have 22 characters in
them. The problem is I do not neet the last ten characters. Is there a function that will read what is in the cell and remove the last ten characters? Thanks in advance for the help. |
#2
|
|||
|
|||
To steal a formula from another Question earlier in the day:
=LEFT(A1,LEN(A1)-10) should do the trick. You can thank JulieD and Frank Kabel for this formula. tj "Daniell" wrote: I have a very large spreadsheet that two of the colums have 22 characters in them. The problem is I do not neet the last ten characters. Is there a function that will read what is in the cell and remove the last ten characters? Thanks in advance for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning left part of cell before a character | Excel Discussion (Misc queries) | |||
how can excel colour a cell when it has a specified character | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
copy paste cell character limit | Excel Discussion (Misc queries) | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |