Croping Text to set char eg "/"

T

Trances

Board Regular
Joined
Nov 16, 2006
Messages
142
Similar to text to coloums but with a formula

I have a coloum of cells ( A )
that has the following
Jim Jackson/DC/London@enter.co.uk
Kim Loydes/HR/London@enter.co.uk
Paul Linter/DC/London@enter.co.uk

in coloum B i want to end up with every thing up till the /

But i dont want to use text to coloums as the data in Coloumn A changes often. I know there is left and right for text but how do you use it to take the chars till it get to set item such as the "/"
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Sort by date Sort by votes
Like this? B1 (copied down):
=LEFT(A1,FIND("/",A1)-1)
Mr Excel.xls
ABCD
1Jim Jackson/DC/London@enter.co.ukJim Jackson
2Kim Loydes/HR/London@enter.co.ukKim Loydes
3Paul Linter/DC/London@enter.co.ukPaul Linter
4
Sheet1
 
Upvote 0
You must log in or register to reply here.

Similar threads

VBA learner ITG
  • Question
VBA Advice on find and replace whole word within a text string
Replies
1
Views
947
VBA learner ITG
VBA learner ITG
T
  • Question
Searching for Text in Multiple PDFs and Returning File Name
Replies
0
Views
4K
turtlepokerman
T
S
  • Question
The Appearance of a Cell & helping me make a udf to not act upon appearance of cell (but to act upon a stored value of the function arguments)
Replies
6
Views
892
Spyros13
S
E
  • Question
Delete File Permission Error
Replies
2
Views
2K
ExcelMacLean
E
I
  • Question
Text format to paragraphs
Replies
2
Views
474
Infologik
I

Forum statistics

Threads
1,215,190
Messages
6,123,547
Members
449,107
Latest member
caya

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top