Apple
Apple
Orange
Apple
I would like to convert Orange to number 1 and Apple to 2.
whats the command for this?
i tried searching on internet but to no availthank you in advance!!
Need help with excel formulas, excel pro plz help
  
 |
|
|
 Feb 7 2018, 10:20 PM, updated 10 months ago
Show posts by this member only | Post
#1
|
 
Group: Junior Member
Posts: 440 Joined: Nov 2014 From: Ipoh, Perak  
|
Orange
Apple Apple Orange Apple I would like to convert Orange to number 1 and Apple to 2. whats the command for this? i tried searching on internet but to no availthank you in advance!! |
Quote|
|
|
|
|
Feb 7 2018, 10:25 PM
Show posts by this member only | Post
#2
|
Group: Junior Member
Posts: 321 Joined: Jan 2003 From: Subang  
|
ctr-F > replace function
|
|
|
Feb 7 2018, 10:25 PM
Show posts by this member only | Post
#3
|
Group: Newbie
Posts: 7 Joined: Oct 2009
|
QUOTE(Cherryx @ Feb 7 2018, 10:20 PM) Orange VlookupApple Apple Orange Apple I would like to convert Orange to number 1 and Apple to 2. whats the command for this? i tried searching on internet but to no availthank you in advance!!  |
|
|
Feb 7 2018, 10:31 PM
Show posts by this member only | Post
#4
|
|
Group: Junior Member
Posts: 440 Joined: Nov 2014 From: Ipoh, Perak
|
QUOTE(gabandell @ Feb 7 2018, 10:25 PM) ctr-F > replace function thank you so much you saved my lifeeeeeeeeee |
|
|
Feb 7 2018, 10:31 PM
Show posts by this member only | Post
#5
|
|
Group: Junior Member
Posts: 440 Joined: Nov 2014 From: Ipoh, Perak
|
QUOTE(nirzah @ Feb 7 2018, 10:25 PM) Vlookup solved the problem already  thank you |
 |
| Switch to: |  0.0677sec
 1.81
 5 queries
 GZIP Disabled
Time is now: 19th November 2018 - 02:17 AM |
All Rights Reserved 2002- 2018 Vijandren Ramadass (~unite against racism~)
Powered by Invision Power Board(Trial) © 2018 IPS, Inc.