Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
[newbie]
Is it possible to get the length of a particular field. For example I would
like to copy the contents of an identification card, which has - a number of numbers (n) - ends with a letter which is usually M, L, A or something else :) So basically I want to tell Excel to format the characters From nnnnn..A where n is a number (0-9), A is an alphabetic character (A-Z), and, the number of numeric characters in n... is unknown I've tried playing about with the RIGHT functions but could not find any functions for the "length of string" so I got stuck. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
[newbie]
Hi
Would you post a sample how your current data is set up and the result that you want. if you want to know how many characters are in the cell, try this =LEN(A2) and copy down this will tell you the numbers of characters in a cell. -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "Jon" wrote: Is it possible to get the length of a particular field. For example I would like to copy the contents of an identification card, which has - a number of numbers (n) - ends with a letter which is usually M, L, A or something else :) So basically I want to tell Excel to format the characters From nnnnn..A where n is a number (0-9), A is an alphabetic character (A-Z), and, the number of numeric characters in n... is unknown I've tried playing about with the RIGHT functions but could not find any functions for the "length of string" so I got stuck. Any ideas? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
[newbie]
Thanks :)
I figured out something like this would format the characters: =LEFT('Employee information'!C2,LEN('Employee information'!C2)-1) & " " & RIGHT('Employee information'!C2,1) "Francis" wrote: Hi Would you post a sample how your current data is set up and the result that you want. if you want to know how many characters are in the cell, try this =LEN(A2) and copy down this will tell you the numbers of characters in a cell. -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "Jon" wrote: Is it possible to get the length of a particular field. For example I would like to copy the contents of an identification card, which has - a number of numbers (n) - ends with a letter which is usually M, L, A or something else :) So basically I want to tell Excel to format the characters From nnnnn..A where n is a number (0-9), A is an alphabetic character (A-Z), and, the number of numeric characters in n... is unknown I've tried playing about with the RIGHT functions but could not find any functions for the "length of string" so I got stuck. Any ideas? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
[newbie]
Hi
Thank for the feedback. Am glad that this point you to the right direction -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "Jon" wrote: Thanks :) I figured out something like this would format the characters: =LEFT('Employee information'!C2,LEN('Employee information'!C2)-1) & " " & RIGHT('Employee information'!C2,1) "Francis" wrote: Hi Would you post a sample how your current data is set up and the result that you want. if you want to know how many characters are in the cell, try this =LEN(A2) and copy down this will tell you the numbers of characters in a cell. -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "Jon" wrote: Is it possible to get the length of a particular field. For example I would like to copy the contents of an identification card, which has - a number of numbers (n) - ends with a letter which is usually M, L, A or something else :) So basically I want to tell Excel to format the characters From nnnnn..A where n is a number (0-9), A is an alphabetic character (A-Z), and, the number of numeric characters in n... is unknown I've tried playing about with the RIGHT functions but could not find any functions for the "length of string" so I got stuck. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Newbie Q | Excel Worksheet Functions | |||
vba newbie need help. | Excel Discussion (Misc queries) | |||
Real Newbie newbie question | New Users to Excel | |||
Can you help a NEWBIE please | Excel Discussion (Misc queries) | |||
Very very new newbie | New Users to Excel |