I want to change the entire column's values. The values are like this

332450 457047024001990 

2 numbers with a white space in between. I only need the first number. This column has more than 5000 rows so it's very hard to do it manually. How can I delete the second number or only see the first number. I'm using Ubuntu.

CodePudding user response：

• You can simply use Find & Replace method.

Use * space and asterisk to replace all things after space. Keep replace with field blank. Then hit Replace All button.

• VBA custom procedure is another option. You can use below formula to adjacent column to extract first part of number (before space).

  =--LEFT(A1,SEARCH(" ",A1)-1)

Then copy full column and paste as values to original column.

Another easier method is Text to Column. Use space as delimiter to separate numbers between space then delete 2nd column.