Specific number to specific word

Y

Yamasaki450

Board Regular
Joined
Oct 22, 2021
Messages
58
Office Version
  1. 2021
Platform
  1. Windows
Hello everyone :)

How can i convert specific number in column to specific word with formula? For example i have numbers 1,2,3 in first column now i want to change 1 to Apple, 2 to Orange, 3 to Banana. It needs to be done all in one go so i can just drag down the formula for the rest of the numbers...

Like this.
 

Attachments

  • Clipboard02.jpg
    Clipboard02.jpg
    77.9 KB · Views: 2

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Sort by date Sort by votes
Create a table with numbers/words.
Then vlookup the number and return the matching word.
 
Upvote 0
You must log in or register to reply here.

Similar threads

dcofer
  • Solved
Locating Words With Specific Letters in a Column
Replies
5
Views
151
dcofer
dcofer
P
  • Question
FILTER function with multiple criteria already in Include syntax
Replies
3
Views
303
Fluff
Fluff
S
  • Solved
Getting excel to return multiple results from one cell
Replies
6
Views
179
Sparhan
S
L
  • Question
Draw data from website
Replies
2
Views
74
Lux Aeterna
L
D
  • Question
Adding the count of repeating values
Replies
6
Views
250
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,214,925
Messages
6,122,303
Members
449,078
Latest member
nonnakkong

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top