Nov 13 2018 08:57 AM
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
Nov 13 2018 09:04 AM
Hi Buzz,
You may try Data->Text to Columns using period as separator. Or Flash Fill if only first number is required.