Change characters in text to other text

**Jonathan11235** · 02-17-2016, 06:43 AM

Hey,

Say I have a cell with the number 312 in it and I want to have in the cell next to it a formula which somehow converts 0 to A, 1 to B, 2 to C, etc. So the next cell would say DBC. Is this possible?

Thanks in advance

**tony h** · 02-17-2016, 07:07 AM

The following will work but (to my mind is rather cumbersome) but may suit if it just the range 1-9 that is in the input side.
You will need to extend it for your purposes.

Formula:

Please Login or Register  to view this content.

Change characters in text to other text

LinkBack

Thread Tools

Rate This Thread

Display

Change characters in text to other text

Re: Change characters in text to other text

Thread Information

Users Browsing this Thread

Similar Threads

Based off of text change, text will import into cells, breaks if text is cleared/deleted

[SOLVED] Formula to delete words from text only if text in over certain amount of characters

Extract text between two characters in a string - varing text length

Macro to change cell format to text and remove unwanted spaces & special characters

[SOLVED] Change text to a single characters

want to remove all text characters equal to one character in length from text string

[SOLVED] want to remove all text characters equal to one character in length from text string

Bookmarks

Bookmarks

Posting Permissions