Vba code to Replace data

**fulldeen** · 02-23-2015, 02:11 PM

Hallo my good friends.
I need a code in order to replace data (kapital letters) with (numbers)given in a specific range of cells.
Please take a look at the attachment.
Thank youin advanced .

**walruseggman** · 02-23-2015, 03:22 PM

This is pretty easy to do using ASCII conversions. In my code, I'm subtracting 64 because the ASCII value of A is 65, B is 66, etc.

If you need to change the conversion numbers in the future, you'll have to adjust the 64 accordingly.

Please Login or Register  to view this content.

**JOHN H. DAVIS** · 02-23-2015, 03:46 PM

FWIW:

Please Login or Register  to view this content.

**fulldeen** · 02-23-2015, 04:03 PM

Many thanks to both of you.

**walruseggman** · 02-23-2015, 04:22 PM

You're welcome. Any reputation points (the * in the bottom of the posts) is appreciated.

Vba code to Replace data

LinkBack

Thread Tools

Rate This Thread

Display

Vba code to Replace data

Re: Vba code to Replace data

Re: Vba code to Replace data

Re: Vba code to Replace data

Re: Vba code to Replace data

Thread Information

Users Browsing this Thread

Similar Threads

VBA Code to replace data in Greek and English

Replace Macro recorded code with more effective code

Comparing a Table with another data Table to replace with a Code

find and replace - replace data in rows to separated by commas

2nd try --Macro to transfer data in an Excel sheet (2000) in Access 2000 ( code to replace what wizard do)

Bookmarks

Bookmarks

Posting Permissions