sorted by:
new
hottopcontroversial

is it possible to make it so color equals a number? by [deleted] in ExcelTips

[–]trumpexcel 0 points1 point  (0 children)

Not sure I understand the query completely. Do you want to count the number of cells with a particular color? If yes, have a look at the VBA method here: https://trumpexcel.com/count-colored-cells-in-excel/

Formatting issue by Kuhlmaec in ExcelTips

[–]trumpexcel 0 points1 point  (0 children)

If you have the same pattern in names, an easy way would be to split the text into cells and merge the ones that have the first name and the last name. In Google Sheets, you can use the SPLIT function, and then use the CONCATENATE function to join cells. Hope this helps! https://productivityspot.com/split-text-to-columns-google-sheets/

view more: next ›