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

Hello,

I am trying to make a formula for text. This is what i want;

In one coloumn i have a category and i want the next coloumn to be the initial of the category and i want the initail to automatically appear everytime i put the designated category. Example:

Coloumn A - Category name - Wash Basin, Coloumn B will automatically gives me an Initail of WB

can somebody help me with this or else i advise me to take an extra training of EXCEL EXPERT.

Thanks to all!!!

Formula for text
Logitech formula vibration feedback wheel driver - Download - Drivers
Date formula in excel dd/mm/yyyy - Guide
Number to words in excel formula - Guide
Excel grade formula - Guide
Credit summation formula - Guide

1 response

Answer 1 / 1

aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 491
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

pie
Apr 5, 2011 at 11:53 PM

thanks aquarelle, i tried it but it didnt work. ijust simply copy & paste it but its not working. Can u you please tell how will i use it? THANKS AGAIN....

aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 491
Apr 6, 2011 at 03:17 AM

Hi,

For example, in your sheet, A2 contains the text "Wash Basin" and the formula is putting in B2 to obtain "WB" :

   
                 A                    B  
1          Product                  ABREV  
2          Wash Basin                =LEFT(A2)&MID(A2,FIND(" ",A2)+1,1)

Best regards

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

formulas for 1st and 2nd position in class

Similar discussions

Subscribe To Our Newsletter!