Home

Take out too much information in a cell in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-803013%22%20slang%3D%22en-US%22%3ETake%20out%20too%20much%20information%20in%20a%20cell%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-803013%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20too%20much%20information%20in%20a%20cell%20in%20Excel%3C%2FP%3E%3CP%3EExample%3A%201234%20Miles%20-%20I%20want%20to%20drop%20Miles%20and%20keep%20the%20numbers%3C%2FP%3E%3CP%3EI%20have%20over%20two%20hundreds%20that%20I%20need%20to%20fix.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20You%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-803013%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-803057%22%20slang%3D%22en-US%22%3ERe%3A%20Take%20out%20too%20much%20information%20in%20a%20cell%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-803057%22%20slang%3D%22en-US%22%3ETry%20this%3A%3CBR%20%2F%3E%3D%E2%80%94LEFT(A2%2C%3CBR%20%2F%3EFIND(%E2%80%9C%20%E2%80%9C%2CA2)-1)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-803098%22%20slang%3D%22en-US%22%3ERe%3A%20Take%20out%20too%20much%20information%20in%20a%20cell%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-803098%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20not%20working%20very%20well%3C%2FP%3E%3CP%3EI%20tried%20using%20this%20formula%20in%20a%20cell%20next%20to%20it%20and%20comes%20up%20%23NAME%3F%3C%2FP%3E%3CP%3EThis%20what%20I%20used%26nbsp%3B%20%3D%E2%80%94LEFT(A2%2CFIND(%E2%80%9C%20%E2%80%9C%2CA2)-1)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-803101%22%20slang%3D%22en-US%22%3ERe%3A%20Take%20out%20too%20much%20information%20in%20a%20cell%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-803101%22%20slang%3D%22en-US%22%3EPlease%20ensure%20that%20the%20LEFT%20function%20is%20preceded%20by%20double%20negatives.%20I%E2%80%99m%20replying%20through%20mobile%20phone%20so%20the%20double%20negatives%20don%E2%80%99t%20appear%20as%20they%20should%20be.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-804993%22%20slang%3D%22en-US%22%3ERe%3A%20Take%20out%20too%20much%20information%20in%20a%20cell%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804993%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F385114%22%20target%3D%22_blank%22%3E%40frontdesksm%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20you%20tried%20%22text%20to%20columns%22%20on%20the%20%22data%22%20tab%3F%20If%20there%20is%20a%20space%20between%20'1234'%20and%20'miles'%2C%20you%20can%20click%20on%20%22fixed%20width%22%20and%20every%20section%20will%20appear%20in%20its%20own%20column.%20Just%20add%20enough%20columns%20next%20to%20the%20cells%20that%20contain%20too%20much%20info.%20Once%20done%2C%20you%20can%20delete%20unwanted%20columns%20and%20keep%20only%20the%20info%20you%20need.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-805033%22%20slang%3D%22en-US%22%3ERe%3A%20Take%20out%20too%20much%20information%20in%20a%20cell%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-805033%22%20slang%3D%22en-US%22%3E%3CP%3EI%20ended%20up%20using%20Data-Text%20to%20Columns%20and%20it%20work%20great.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20You!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F391459%22%20target%3D%22_blank%22%3E%40J_Uys123%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
frontdesksm
Occasional Contributor

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,

5 Replies
Try this:
=—LEFT(A2,
FIND(“ “,A2)-1)

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)

 

 

@Twifoo 

Please ensure that the LEFT function is preceded by double negatives. I’m replying through mobile phone so the double negatives don’t appear as they should be.

@frontdesksm 

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.

 

I ended up using Data-Text to Columns and it work great. 

 

Thank You!!

 

@J_Uys123 

Related Conversations