Welcome Guest ( Log In | Register )

Forum Announcement

New user registrations disabled until further notice.

Bump TopicClosed TopicRSS feed Start new topic Start Poll

Outline · [ Standard ] · Linear+

> Need help with excel formulas, excel pro plz help

Cherryx
post Feb 7 2018, 10:20 PM, updated 4 months ago

Casual
***
Group: Junior Member
Posts: 438

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? sad.gif i tried searching on internet but to no avail

thank you in advance!!
gabandell
post Feb 7 2018, 10:25 PM

Casual
***
Group: Junior Member
Posts: 319

Joined: Jan 2003
From: Subang



ctr-F > replace function
nirzah
post Feb 7 2018, 10:25 PM

New Member
*
Group: Newbie
Posts: 5

Joined: Oct 2009
QUOTE(Cherryx @ Feb 7 2018, 10:20 PM)
Orange
Apple
Apple
Orange
Apple
I would like to convert Orange to number 1 and Apple to 2.
whats the command for this? sad.gif i tried searching on internet but to no avail

thank you in advance!!
*
Vlookup
Cherryx
post Feb 7 2018, 10:31 PM

Casual
***
Group: Junior Member
Posts: 438

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
Cherryx
post Feb 7 2018, 10:31 PM

Casual
***
Group: Junior Member
Posts: 438

Joined: Nov 2014
From: Ipoh, Perak



QUOTE(nirzah @ Feb 7 2018, 10:25 PM)
Vlookup
*
solved the problem already happy.gif thank you

Bump TopicClosed TopicTopic OptionsStart new topic
 

Switch to:
| Lo-Fi Version
0.0595sec    1.96    5 queries    GZIP Disabled
Time is now: 25th May 2018 - 05:41 AM