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

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
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

T
  • Question
find column value
Replies
1
Views
288
duggie33
D
P
  • Solved
Extract a number before specific letters
2
Replies
14
Views
2K
Pank
P
A
  • Solved
vba code counting specific word in multiples sheets
Replies
7
Views
252
azizls4
A
E
  • Solved
Index/Match - Return value if partial text from cell contained in separate column
2
Replies
16
Views
2K
Kevin_Li
Kevin_Li
M
  • Solved
condition check for multiple words
2
Replies
10
Views
589
awoohaw
awoohaw

Forum statistics

Threads
1,214,866
Messages
6,121,996
Members
449,060
Latest member
mtsheetz

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