Thread: Delete first word
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default 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
---
Reply With QuoteReply With Quote