Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I remove the 1st 4 characters of a field in Excel?
How do I remove the 1st 4 characters of a field in Excel?
|
#2
|
|||
|
|||
=MID(A1,5,255)
If the result is numeric for sure, you can use =1*MID(A1,5,255) or =MOD(A1,100000) Bob Umlas Excel MVP "MFreeman" wrote in message ... How do I remove the 1st 4 characters of a field in Excel? |
#3
|
|||
|
|||
Amendment to previous response. the cells have more than 255 characters.
That's the max column width. "MFreeman" wrote: How do I remove the 1st 4 characters of a field in Excel? |
#4
|
|||
|
|||
=mid(a1,4,30)
If your results are more than 30 characters long, you'll have to change that. The maximum column width is 255 characters. "MFreeman" wrote: How do I remove the 1st 4 characters of a field in Excel? |
#5
|
|||
|
|||
=mid(A1,5,255) where A1 is your data and 255 <= the length of data in the cell. HTH Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=377825 |
#6
|
|||
|
|||
MFreeman wrote:
How do I remove the 1st 4 characters of a field in Excel? =REPLACE(A2,1,4,"") |
#7
|
|||
|
|||
If A1 contains text THEREFORE YOU and the formula in B2 is
=MID(A1,5,LEN(A1)-4) then EFORE YOU is returned. HTH Rob "Aladin Akyurek" wrote in message ... MFreeman wrote: How do I remove the 1st 4 characters of a field in Excel? =REPLACE(A2,1,4,"") |
#8
|
|||
|
|||
I guess you didn't try the REPLACE formula.
Rob wrote: If A1 contains text THEREFORE YOU and the formula in B2 is =MID(A1,5,LEN(A1)-4) then EFORE YOU is returned. HTH Rob "Aladin Akyurek" wrote in message ... MFreeman wrote: How do I remove the 1st 4 characters of a field in Excel? =REPLACE(A2,1,4,"") -- [1] The SumProduct function should implicitly coerce the truth values to their Excel numeric equivalents. [2] The lookup functions should have an optional argument for the return value, defaulting to #N/A in its absence. |
#9
|
|||
|
|||
By "remove", if you mean that you WANT the first four characters "only",
then use...... =LEFT(A1,4) Vaya con Dios, Chuck, CABGx3 "MFreeman" wrote in message ... How do I remove the 1st 4 characters of a field in Excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
remove non-numeric characters from a cell | Excel Discussion (Misc queries) | |||
Remove characters from a text string using a formula | Excel Discussion (Misc queries) | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
Remove 1st 3 characters in each field of Excel column | Excel Worksheet Functions |