LinkBack URL
About LinkBacks
have just done this - but it'ssaying #value! (copy and pasted from your message!)
Thank you for your help!
have just done this - but it'ssaying #value! (copy and pasted from your message!)
Thank you for your help!
Have you put a name in A1?
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
No, first name is B1
If your name (i.e. Mary Jo Smith) is in B1, then then formula needs editing to that cell reference
=RIGHT(B1,LEN(B1)-FIND("^^",SUBSTITUTE(B1," ","^^",LEN(B1)-LEN(SUBSTITUTE(B1," ","")))))
is still saying the same.
Can you provide a small zipped sample of your data, this will be easier to understand what you are trying to do, then hopefully a solution can be found.
To post a zipped example, go to “My Documents” or wherever you have your file stored, right-click and “Sent to > Compressed file”, then attach this to your post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks