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
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies