Aug 13 2019 09:23 AM
I have too much information in a cell in Excel
Example: 1234 Miles - I want to drop Miles and keep the numbers
I have over two hundreds that I need to fix.
Thank You,
Aug 13 2019 09:59 AM
Aug 13 2019 10:19 AM
This is not working very well
I tried using this formula in a cell next to it and comes up #NAME?
This what I used =—LEFT(A2,FIND(“ “,A2)-1)
Aug 13 2019 10:24 AM
Aug 14 2019 09:14 AM
Have you tried "text to columns" on the "data" tab? If there is a space between '1234' and 'miles', you can click on "fixed width" and every section will appear in its own column. Just add enough columns next to the cells that contain too much info. Once done, you can delete unwanted columns and keep only the info you need.
Aug 14 2019 09:36 AM