Solved

Remove data from Excel cell

Posted on 2014-10-01
4
177 Views
Last Modified: 2014-10-02
I have the attached an excel file where I have data like this AS-P31-111   25   00

Up to the first 3 spaces it is the SKU"AS-P31-111" and I want to remove everything starting at the 3 spaces

Can someone help with the formula to do this?
sample.xlsx
0
Comment
Question by:Gerhardpet
4 Comments
 
LVL 21

Accepted Solution

by:
Tapan Pattanaik earned 400 total points
ID: 40355356
Hi  Gerhardpet ,

Your answer to your question is : =LEFT(A2,11) . Please find the attached excel sheet.

Reagards,
Tapan Pattanaik
Answer--sample.xlsx
0
 
LVL 27

Assisted Solution

by:Glenn Ray
Glenn Ray earned 100 total points
ID: 40355362
Here is a more open-ended formula (in same row as A2, then copied down):
=LEFT(A2,FIND("   ",A2)-1)

It doesn't matter how many characters there are before the three spaces.

Regards,
-Glenn
0
 
LVL 33

Expert Comment

by:Rob Henson
ID: 40356634
Alternatively, use the Text to Columns function to split the text at the spaces.

Thanks
Rob H
0
 
LVL 1

Author Closing Comment

by:Gerhardpet
ID: 40356826
That worked! Thanks for the help!
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question