Filter out values in a column

Copper Contributor

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

1 Reply

Hi Buzz,

 

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