| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Deleting a consistant portion of all cells in a given column
I need to remove only the first 10 characters of 40 character cells in a
given column. What is the formula to produce this result? All cells are currently 40 characters in length. -- clock |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Deleting a consistant portion of all cells in a given column
I need to remove only the first 10 characters of 40 character cells in a
given column. What is the formula to produce this result? All cells are currently 40 characters in length. =MID(A2,11,999) Rick |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Deleting a consistant portion of all cells in a given column
I need to remove only the first 10 characters of 40 character cells in a
given column. What is the formula to produce this result? All cells are currently 40 characters in length. =MID(A2,11,999) I realize you said all of your text is 40 characters in length which means you could have used this instead... =MID(A2,11,30) but if your text ever got longer, the extra characters from character position 41 onward would be truncated away. Using a number larger than you need will protect against your text ever becoming longer. Another possibility, which automatically protects against longer text being introduced later on is this formula... =REPLACE(A4,1,10,"") Rick |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Deleting a consistant portion of all cells in a given column
=mid(a2,11,len(a2))
"clock" wrote in message ... I need to remove only the first 10 characters of 40 character cells in a given column. What is the formula to produce this result? All cells are currently 40 characters in length. -- clock |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Deleting a consistant portion of all cells in a given column
=right(a1,30)
"clock" wrote: I need to remove only the first 10 characters of 40 character cells in a given column. What is the formula to produce this result? All cells are currently 40 characters in length. -- clock |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i remove a portion of data from a column | Excel Discussion (Misc queries) | |||
| Sort a column of email addresses by end portion of address | Excel Discussion (Misc queries) | |||
| HOW TO MAKE A MAILING LIST IN ONE COLUMN HAVE CONSISTANT ROWS | Excel Discussion (Misc queries) | |||
| Remove portion of text from cells | Excel Discussion (Misc queries) | |||
| Deleting blank cells in a column | Excel Discussion (Misc queries) | |||
Hybrid Mode
