Formula for text

Solved/Closed
pie - Apr 5, 2011 at 07:26 AM
aquarelle
Posts
7118
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
July 29, 2022
- 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!!!

1 reply

aquarelle
Posts
7118
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
July 29, 2022
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
0
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....
0
aquarelle
Posts
7118
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
July 29, 2022
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
0