By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,398 Members | 957 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,398 IT Pros & Developers. It's quick & easy.

Trim function in Excel

P: 16
Hi guys,

I know this is a Access Forum but i had an excel question.

I wanted to know if anyone knew a way i could delete part of a record for example after the first space.

e.g THY0056 London to THY0056 (removing the London)

I came across the Trim function.....Can i use this or would i have to do it another way.

I have 10,000 fields to get through and deleting the data manually is taking alot of time.

Does anyone know how this could be done?

Many thanks
Dec 6 '07 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 635
Hi guys,

I know this is a Access Forum but i had an excel question.

I wanted to know if anyone knew a way i could delete part of a record for example after the first space.

e.g THY0056 London to THY0056 (removing the London)

I came across the Trim function.....Can i use this or would i have to do it another way.

I have 10,000 fields to get through and deleting the data manually is taking alot of time.

Does anyone know how this could be done?

Many thanks
Hi

Try

=LEFT(D3,FIND(" ",D3,1))

where THY0056 London is in cell D3

MTB
Dec 6 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.