Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LEN fuction to leave a single character
What is the LEN fuction to leave a single character from a text string.
I need the initial letter from a name and the last letter. How do i join LEN fuctions togetehr into a single formula? J LEN fuction to leave a single character |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LEN fuction to leave a single character
"Jonah" wrote in message
... What is the LEN fuction to leave a single character from a text string. I need the initial letter from a name and the last letter. How do i join LEN fuctions togetehr into a single formula? J LEN fuction to leave a single character Jonah, Should be LEFT() or RIGHT() function Beege |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LEN fuction to leave a single character
"I need the initial letter from a name and the last letter" - use this formula
=LEFT(A1,1)&RIGHT(A1,1) examle: "John Smith" will return "Jh" the rest of your post is rather confusing because the LEN function returns the length of a text string. LEN("John Smith") will return 10. "How do i join LEN fuctions togetehr into a single formula?" - I assume you mean any text function (ie LEFT, RIGHT, MID, SUBSTITUTE, etc.). Use the & symbol LEFT("John",1)&Right("Smith",1) will return "Jh" "John"&"Smith" will return "JohnSmith" "Jonah" wrote: What is the LEN fuction to leave a single character from a text string. I need the initial letter from a name and the last letter. How do i join LEN fuctions togetehr into a single formula? J LEN fuction to leave a single character |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LEN fuction to leave a single character
Another great solution.
P.S. How do I start to lookup a formula event when I do not have the event name to look up. If I knew it was RIGHT I would not necessarily need the help of a newsgroup. I was using LEFT(K2, LEN(K2)-3) to reduce the length of the string by changing the value 3, to 2 and so on. Not a very neat solution I must add. J ========== Sloth wrote: "I need the initial letter from a name and the last letter" - use this formula =LEFT(A1,1)&RIGHT(A1,1) Example: "John Smith" will return "Jh" |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LEN fuction to leave a single character
Jonah,
You knew "LEN" Activate help in Excel for LEN Right below LEN, look at "SEE ALSO" its in blue. Click on it. It gets you to other usable text and data functions,and s short description of wht they do. Give it a shot... and good luck Beege "Jonah" wrote in message ... Another great solution. P.S. How do I start to lookup a formula event when I do not have the event name to look up. If I knew it was RIGHT I would not necessarily need the help of a newsgroup. I was using LEFT(K2, LEN(K2)-3) to reduce the length of the string by changing the value 3, to 2 and so on. Not a very neat solution I must add. J ========== Sloth wrote: "I need the initial letter from a name and the last letter" - use this formula =LEFT(A1,1)&RIGHT(A1,1) Example: "John Smith" will return "Jh" |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LEN fuction to leave a single character
In help, click on the Contents tab, click Creating Formulas And Auditing
Workbooks, Using Functions you should see a listing of functions broken down by category w/hyperlinks to each functions description. "Jonah" wrote: Another great solution. P.S. How do I start to lookup a formula event when I do not have the event name to look up. If I knew it was RIGHT I would not necessarily need the help of a newsgroup. I was using LEFT(K2, LEN(K2)-3) to reduce the length of the string by changing the value 3, to 2 and so on. Not a very neat solution I must add. J ========== Sloth wrote: "I need the initial letter from a name and the last letter" - use this formula =LEFT(A1,1)&RIGHT(A1,1) Example: "John Smith" will return "Jh" |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LEN fuction to leave a single character
I don't know if you are still reading this, but there is a button in the
Standard Toolbar called "Paste Function". Select a blank cell and click it. This bring up a function wizard with categories on the left and functions on the right. If you select a function you can ask the paperclip about it by pressing the question mark in the bottom left of the paste function window. I don't think any function in the Add-ins toolpak is included, and DATEDIF is not included. I think most if not all of the other functions are listed. Anyways, there is a category called text which show all of the text functions. "Jonah" wrote: Another great solution. P.S. How do I start to lookup a formula event when I do not have the event name to look up. If I knew it was RIGHT I would not necessarily need the help of a newsgroup. I was using LEFT(K2, LEN(K2)-3) to reduce the length of the string by changing the value 3, to 2 and so on. Not a very neat solution I must add. J ========== Sloth wrote: "I need the initial letter from a name and the last letter" - use this formula =LEFT(A1,1)&RIGHT(A1,1) Example: "John Smith" will return "Jh" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format numberformat Single | Excel Worksheet Functions | |||
how do I make single character as a variable in an array | Excel Worksheet Functions | |||
How can I combine multiple characters into a single character? | Excel Discussion (Misc queries) | |||
is it possible to use F9 to manually calculate in a single sheet or single workbook? | Excel Discussion (Misc queries) | |||
Test for Single Character That is in an Array | Excel Worksheet Functions |