Forum Discussion

Buzz Burgett's avatar
Buzz Burgett
Copper Contributor
Nov 13, 2018

Filter out values in a column

I have a column with two separate numbers in each cell separated by a period and spaces that I need to separate into two columns or save the first number before the period and remove the second number and need the steps to do this. Thank you

  • Hi Buzz,

     

    You may try Data->Text to Columns using period as separator. Or Flash Fill if only first number is required.

Resources