| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete first word
How can I delete the first word in column A?
Thank you -- deb |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete first word
How can I delete the first word in column A?
One way Try in B1: =IF(LEN(A1)=0,"",IF(ISERROR(SEARCH(" ",A1)),A1,TRIM(MID(A1,SEARCH(" ",A1),99)))) Copy down -- Max Singapore http://savefile.com/projects/236895 Downloads:18,000 Files:359 Subscribers:56 xdemechanik --- |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete first word
On Sat, 20 Sep 2008 16:31:01 -0700, deb wrote:
How can I delete the first word in column A? Thank you You can use a formula in some other column: =MID(A1,FIND(" ",A1&" ")+1,255) Then copy the results and do a paste special/values over the original. There are other ways, using VBA and macros, if this is not sufficient. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete space after word | Excel Discussion (Misc queries) | |||
| how do i delete a * at the end of each word in a column | New Users to Excel | |||
| delete a word from end of a text | Excel Worksheet Functions | |||
| Delete all contents of cell but one word | Excel Discussion (Misc queries) | |||
| delete cell that doesn't contain a specific word | Excel Discussion (Misc queries) | |||
Linear Mode
