There are a few names that need to be cleaned up.. example Bob Decker (row 22) has an unusual character at the end of his name. how can i get the code for this character?What is the formula??

Question

There are a few names that need to be cleaned up.. example Bob Decker (row 22) has an unusual character at the end of his name. how can i get the code for this character?What is the formula??

Anonymous

Hi..,

I need some assistance here:

There are a few names that need to be cleaned up.

example Bob Decker (row 22) has an unusual character at the end of his name. how can I get the code for this character?

What is the formula??

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous

Hi Hady M!

I am Shakiru, an independent advisor and a user like you, and I am glad to be helping you out today.

To identify the unusual character at the end of the name "Bob Decker" in row 22, you can use the following formula:

=CODE(RIGHT(A22,1))

This formula will take the last character from cell A22 (assuming the name is in cell A22), and return its Unicode value as a number. The CODE function converts a character into its Unicode value.

Once you have the Unicode value of the unusual character, you can use it to find and replace it with a regular character, such as a space or a hyphen, using Excel's "Find and Replace" feature.

Kindly let me know, if you require additional assistance, I will be glad to help further.

Kind Regards, Shakiru

0 comments

1 additional answer

Answer 1

Anonymous

Hi Shakiru

Thank you for your assistance it works now appreciate

0 comments

Share via

There are a few names that need to be cleaned up.. example Bob Decker (row 22) has an unusual character at the end of his name. how can i get the code for this character?What is the formula??

1 additional answer