you use a spreadsheet function to divide the text strings in column g around the commas and put each fragment into a new, separate cell. in this example, what are the commas called?



Answer :

Use SPLIT to create a new, independent cell for each colour in Column G. A spreadsheet function called SPLIT separates text around a given character and places each fragment in a new, distinct cell.

What tool would you employ to look for a specific value in a spreadsheet column?

When data is listed in columns, the vertical lookup function, or VLOOKUP, is utilised. This process looks for a value in the left-most column and compares it to information in a certain column in the same row. In a sorted or unsorted table, you can use VLOOKUP to find data.

Learn more about commas

https://brainly.com/question/14588824

#SPJ4