Previous Topic Next Topic

Formula for text

Solved/Closed
pie - Apr 5, 2011 at 07:26 AM
aquarelle Posts 7435 Status Moderator - 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 response

Answer 1 / 1
aquarelle Posts 7435 Status Moderator 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 7435 Status Moderator 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
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses