Formula for text
Solved/Closed
pie

Apr 5, 2011 at 07:26 AM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024  Apr 6, 2011 at 03:17 AM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024  Apr 6, 2011 at 03:17 AM
Related:
 Formula for text
 Logitech formula vibration feedback wheel driver  Download  Drivers
 Excel grade formula  Guide
 Number to words in excel formula  Guide
 Date formula in excel dd/mm/yyyy  Guide
 Credit summation formula  Guide
1 response
aquarelle
Posts
7140
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
March 25, 2024
491
Apr 5, 2011 at 10:52 AM
Apr 5, 2011 at 10:52 AM
Hi,
Try with this formula in column B :
=LEFT(A2)&MID(A2,FIND(" ",A2)+1,1)
Best regards
Try with this formula in column B :
=LEFT(A2)&MID(A2,FIND(" ",A2)+1,1)
Best regards
Apr 5, 2011 at 11:53 PM
Apr 6, 2011 at 03:17 AM
For example, in your sheet, A2 contains the text "Wash Basin" and the formula is putting in B2 to obtain "WB" :
Best regards