Problem with search

  • Thread starter Thread starter Manu Palao
  • Start date Start date
M

Manu Palao

Hi
the problem arises when the cell only has a word. When I try to get th
position of the blank character (to be able to separate the first wor
by means of MID function), there is an error, because there is no blan
in the cell.Thanks
 
Hi
then try
=IF(ISNUMBER(FIND(" ",A1)),MID(A1,FIND(" ",A1)+1,1024),A1)

P.S.: best to post your tried formula
 
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

Scrabble Value calculation for Welsh words 0
Avoiding the dreaded #div/0 error 10
Statistics, #N/A and dynamic range problem 4
Blianking Empty Lines In a Report 1
Autofilter and zero's in blank field questions. 3
MID / LEN 2
Max values from 2 ws and a range 6
T.Valko function 5

Back
Top