| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
deleting text after a certain word
Is there a way to remove all text after a word in a cell.
Example: 1.75" radius per mit. 1.75" radius Thanks, -- clcnewtoaccess |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
deleting text after a certain word
You can double-click on the cell,move the cursor to the end of the data you
want to delete and press backspace until it is gone. Then press the enter key to complete the edit. -- LPS "clcnewtoaccess" wrote: Is there a way to remove all text after a word in a cell. Example: 1.75" radius per mit. 1.75" radius Thanks, -- clcnewtoaccess |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
deleting text after a certain word
Something like this:
=LEFT(A1,FIND("radius",A1)+5) Regards, Fred "clcnewtoaccess" wrote in message ... Is there a way to remove all text after a word in a cell. Example: 1.75" radius per mit. 1.75" radius Thanks, -- clcnewtoaccess |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
deleting text after a certain word
Hi
Control+H to bring up Find and Replace Find radius per mit Replace radius Replace All -- Regards Roger Govier clcnewtoaccess wrote: Is there a way to remove all text after a word in a cell. Example: 1.75" radius per mit. 1.75" radius Thanks, |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
deleting text after a certain word
Sorry I didn't make myself clear.
I have some 25,000 lines to do this in and sometimes there are more words after and somethime less. Thanks, -- clcnewtoaccess "LPS" wrote: You can double-click on the cell,move the cursor to the end of the data you want to delete and press backspace until it is gone. Then press the enter key to complete the edit. -- LPS "clcnewtoaccess" wrote: Is there a way to remove all text after a word in a cell. Example: 1.75" radius per mit. 1.75" radius Thanks, -- clcnewtoaccess |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
deleting text after a certain word
I believe you can use the search/replace feature
for the example you listed pull up the replace menu search: radius* replace: radius that should do it "LPS" wrote: You can double-click on the cell,move the cursor to the end of the data you want to delete and press backspace until it is gone. Then press the enter key to complete the edit. -- LPS "clcnewtoaccess" wrote: Is there a way to remove all text after a word in a cell. Example: 1.75" radius per mit. 1.75" radius Thanks, -- clcnewtoaccess |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
deleting text after a certain word
I would be inclined to use a formula such as this...
=LEFT(A1,FIND("radius",A1) + 5) Where your text is in cell A1. -- HTH... Jim Thomlinson "clcnewtoaccess" wrote: Is there a way to remove all text after a word in a cell. Example: 1.75" radius per mit. 1.75" radius Thanks, -- clcnewtoaccess |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
deleting text after a certain word
Just to clarify. The reason I would be inclined to use a formula is that I
have an aversion to deleting things. If you delete the trailing text there is no way to get it back. If somewhere in the 25,000 records some of them go wrong for some reason or you just want to see what it used to look like then you are in trouble with a replace. -- HTH... Jim Thomlinson "Jim Thomlinson" wrote: I would be inclined to use a formula such as this... =LEFT(A1,FIND("radius",A1) + 5) Where your text is in cell A1. -- HTH... Jim Thomlinson "clcnewtoaccess" wrote: Is there a way to remove all text after a word in a cell. Example: 1.75" radius per mit. 1.75" radius Thanks, -- clcnewtoaccess |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
deleting text after a certain word
Jim, the 1.75" is not a fixed length it varies from 3 to 7 charachters in
length such as .5", 12.00", 125.00" and so on. Thanks, -- clcnewtoaccess "Jim Thomlinson" wrote: I would be inclined to use a formula such as this... =LEFT(A1,FIND("radius",A1) + 5) Where your text is in cell A1. -- HTH... Jim Thomlinson "clcnewtoaccess" wrote: Is there a way to remove all text after a word in a cell. Example: 1.75" radius per mit. 1.75" radius Thanks, -- clcnewtoaccess |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
deleting text after a certain word
Jim's formula works regardless of the length of the measurement. In his
example, it will return all the characters in A1 from the first character through the "s" in the word radius. FIND("radius",A1) returns the position within the contents of A1 where the word radius begins. The +5 is to include the rest of the word radius. Hope this helps, Hutch "clcnewtoaccess" wrote: Jim, the 1.75" is not a fixed length it varies from 3 to 7 charachters in length such as .5", 12.00", 125.00" and so on. Thanks, -- clcnewtoaccess "Jim Thomlinson" wrote: I would be inclined to use a formula such as this... =LEFT(A1,FIND("radius",A1) + 5) Where your text is in cell A1. -- HTH... Jim Thomlinson "clcnewtoaccess" wrote: Is there a way to remove all text after a word in a cell. Example: 1.75" radius per mit. 1.75" radius Thanks, -- clcnewtoaccess |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting a word from a Cell | Excel Discussion (Misc queries) | |||
| Deleting the text without deleting the formula | Excel Worksheet Functions | |||
| Deleting Text | New Users to Excel | |||
| deleting phrases in Excel and/or Word | New Users to Excel | |||
| Deleting a Row if it contains a specific word | Excel Discussion (Misc queries) | |||
Linear Mode
