• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

MID Find

K

Kelli*

New Member
Hello,

I would like help resolving the following MID Find issue. I would like column B to return the cost centre in column A i.e. it is the 4th section with 5#chars, as per column C.

At this stage I have 4 businesses that start with a prefix of either 1, 4, 5 or 7 but not limited to these.

Is there a way for it to return the 5#char from between the 3rd & 4th ","?

thank you for you help, I always appreciate it!

Kelli
 

Attachments

  • TimeSpent cost centre.xlsm
    9.9 KB · Views: 7
Like "W.O.W" talk about fastest finger 1st!

You are amazing!! that's perfect, thank you again!!

Kelli
 
NARAYANK991 said:
Hi ,

Try this :

=MID(A2,FIND("| ", SUBSTITUTE(A2,",","|",3))+2, 5)+0

See the attached file.

Narayan
Click to expand...

Narayan,

What if I want to return the #char that appear before the first "," in the string i.e. it would be on of the following, between 2 & 4 #chars

SAW
TWH
SCPH
HB

I would like to understand how this works at some stage of my career, but atm it isn't registering.

kind regards,

Kelli
 
rahulshewale1 said:
Hii @Kelli* ,

another option,
Cell C2 Copy down:

MID(A2,FIND("NA",A2)+4,5)+0


Regard
Rahul shewale
Click to expand...

Hi Rahul,

Yes your formula also worked, but unbeknownst to me my report didn't cover enough of the complexities i.e. all the examples I provided had "NA" when in fact this has numerous variables.

Sorry for the late response, I had some IT issues that put me behind.

I really appreciate your assistance!

Kelli
 
Hi Naresh, Similar to the response I left for Rahaul, my example didn't cover all the variables. In regards, to NA it worked a treat.
Thank you to you also, I hope to continue to build my skill with the assistance of you All!
Kelli
 
You must log in or register to reply here.
Back
Top