Problem with search

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
 
F

Frank Kabel

Hi
then try
=IF(ISNUMBER(FIND(" ",A1)),MID(A1,FIND(" ",A1)+1,1024),A1)

P.S.: best to post your tried formula
 

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

Excel does not accept text format! 0
Lookup or search using the * character 1
How to make scroll bar permanently visible, Word 365 0
WORD VBA Search and switch to advanced ... 1
Conditional Formatting Conundrum 3
If formula producing #VALUE Error 2
Internal Data Integrity (Type 4) Details Needed 1
Cell data entering slow! 0

Top