replace numbers with names

		Microsoft Office Forums > Microsoft Excel > Excel
replace numbers with names

FAQ

Mark Forums Read

Thread Tools

Display Modes

04-01-2017, 09:45 AM

xor

Windows 10 replace numbers with names

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

If you in the attached file anywhere in A1:Z100 enter one of the numbers 1 to 8 Excel will automatically change that number to the corresponding name according to your list.

Attached Files

ReplaceWhenEntering.xlsm (19.4 KB, 13 views)

Tags

names, numbers, replace

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find and replace BETWEEN numbers	WordUser2015	Word	4	12-19-2014 02:09 PM
Replace 0000s with a series of numbers	tingker	Word VBA	2	12-17-2014 06:06 AM
Find and replace inside strings containing various names	audioman	Word VBA	4	03-25-2014 11:19 AM
find and replace consecutive numbers	kpl_39	Word	1	06-07-2013 05:04 AM
Find & Replace formula for numbers?	Griff	Word	4	04-18-2011 02:47 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:50 PM.