spaces2

G

Guest

Hi all, how do I find the first space from the right or the last space from
the left in a string of 30 chars e.g. "the rainfall is very heavy thi"

Thanks as always
PS Ishould have added that the string is only one of several hundred, i.e
its a column of cells c1:c800. and they are all different

thanks again.
 
G

Guest

Try:-

=FIND("^^",SUBSTITUTE(" "&A1," ","^^",LEN(" "&A1)-LEN(SUBSTITUTE(" "&A1,"
",""))))-1

Mike
 

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

spaces 3
Excel Subtract text after the third space and before the fourth (from between spaces) 3
Removing words from a string? 4
Extract only part of a string 6
days of the current month 2
wildcards with substitute of replace 5
<= in the numeric format 1
Time Calculations Help 4

Top