searching a range

  • Thread starter Thread starter Rich Cooper
  • Start date Start date
R

Rich Cooper

this is similar to my previous question. I have a range of names. I want
to search it for a space and put the part before the space in a new range
and everything after the space in a range right next to the one containing
the first part. I have tried the search function but i can not get it to
work. Please Help.
 
Hi
a formula solution:
B1:
=LEFT(A1,FIND(" ",A1)-1)

C1:
=MID(A1,FIND(" ",A1)+1,255)
 
You must log in or register to reply here.

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

VBA set thick borders around non empty cells in range 0
Post my named ranges in column A 10
Paste a range and shifting away existing data 1
Named Range maker code 9
Excel JUMP FROM SEARCH BAR TO RESULT 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Variable Range, selecting/copying 1
Help With MS Access 4

Back
Top