Formula for text

[Solved/Closed]
Report
-
Posts
7098
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 10, 2021
-
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

Posts
7098
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 10, 2021
488
Hi,

Try with this formula in column B :
=LEFT(A2)&MID(A2,FIND(" ",A2)+1,1)

Best regards
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....
Posts
7098
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 10, 2021
488
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