I have a list of values that is seperated by a return. How do I sort each cell in alphabetical order without moving the row?
Need some help on retrieve unique values into column E. Please refer below for samples. i have tried vlookup and hlookup but can't work :(
Dear Excel Community,
Currently I have multiple cells with data arranged like the example below:
Watermelon & Mangosteen
Using this formula :
For Each UsedCell In Selection
Cells.Replace What:=Chr(10), Replacement:=" "
My data gets rearranged to...
I have to change the name as per the group in 'Type' column. it is working fine if it is represented as single name, but not with multiple names.
Eg., For Apple, Orange, Watermelon, it should come as Medium, Soft
Formula used in 'Type' Column -...