Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Abbreviation for "Rear Derailleur" as "RD"
Can any one help me to make an abbreviation in excel file?
This is the example: "Rear Derailleur" to "RD" "Front Suspension Fork" to "FSF" Thanks for your help! |
#2
|
|||
|
|||
In what way, Sammy? You can just do a Find/Replace or create an Autocorrect
entry (in Word, if it's not available in Excel). ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Sammy in Taiwan" <Sammy in wrote in message ... Can any one help me to make an abbreviation in excel file? This is the example: "Rear Derailleur" to "RD" "Front Suspension Fork" to "FSF" Thanks for your help! |
#3
|
|||
|
|||
Is there any function that I can use on excel for this job? precisely I
should say: make an acronym for it! Anne, thanks for your response. "Anne Troy" 來函: In what way, Sammy? You can just do a Find/Replace or create an Autocorrect entry (in Word, if it's not available in Excel). ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Sammy in Taiwan" <Sammy in wrote in message ... Can any one help me to make an abbreviation in excel file? This is the example: "Rear Derailleur" to "RD" "Front Suspension Fork" to "FSF" Thanks for your help! |
#4
|
|||
|
|||
I'm sorry if I wasn't clear, Sammy. What do you mean "make an acronym"? What
will happen if we accomplish your goal? You'll type RD and the words Rear Derailleur will appear? Sorry. :) ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Sammy in Taiwan" wrote in message ... Is there any function that I can use on excel for this job? precisely I should say: make an acronym for it! Anne, thanks for your response. "Anne Troy" ??: In what way, Sammy? You can just do a Find/Replace or create an Autocorrect entry (in Word, if it's not available in Excel). ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Sammy in Taiwan" <Sammy in wrote in message ... Can any one help me to make an abbreviation in excel file? This is the example: "Rear Derailleur" to "RD" "Front Suspension Fork" to "FSF" Thanks for your help! |
#5
|
|||
|
|||
Probably best to write a UDF
Function Acronyms(text) Dim i As Long Dim sTemp If TypeName(text) = "Range" Then If text.Count 1 Then Exit Function End If End If For i = 1 To Len(text) If Mid(text, i, 1) Like "[A-Z]" Then sTemp = sTemp & Mid(text, i, 1) End If Next i Acronyms = sTemp End Function and use like =Acronyms(A1) -- HTH Bob Phillips "Sammy in Taiwan" <Sammy in wrote in message ... Can any one help me to make an abbreviation in excel file? This is the example: "Rear Derailleur" to "RD" "Front Suspension Fork" to "FSF" Thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use a measurement abbreviation in cell with formula | Excel Discussion (Misc queries) | |||
spell out state name from an abbreviation | Excel Discussion (Misc queries) |