[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?

[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?

[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?

[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?