Thread: Formula Halp - If or Lookup
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Diane Diane is offline
external usenet poster
  
Posts: 96
Default Formula Halp - If or Lookup
THANKS! It worked perfectly!!

"dan dungan" wrote:

Does the formula below work for you?

=LEFT(AO1,1)&MID(AO1,FIND(" ",AO1)+1,1)



Reply With QuoteReply With Quote