Splitting Text

  • Thread starter Thread starter jazzzbo
  • Start date Start date
J

jazzzbo

I have a worksheet with data split by a "/" eg. BARRISTER/F. GREY
I want to split the data into two adjacent columns
eg "BARRISTER", "F. GREY"

I have tried =LEFT(A1,FIND("/",A1)-1) for the first field, which works,
and =MID(A1,FIND("/",A1,99)for the second, which doesn't, of course (I
understand why).

What should I do,instead, please?

Jim Berglund
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

data splitting 1
How to split number and text string to separate cells? 5
Split Text 6
VBA Multiple Line handling with Split() 1
Split cell based on UPPERCASE text 1
Split data in field on character return 0
splitting text in a cell.. 5
Splitting Data from One Worksheet to Many Automatically 3

Back
Top