Search results

I dint have textsplit in my version

The path is irrelevant some are in third position some are second so it’s a headache no worries All good don’t stress much! Rest I’ll make manual adjustments, thanks a bunch have a great weekend

It did answered 80% but some has path as below : path:C:\Users\dv2\BMC Software\Control But I need third string ‘BMC Software’

Some come with correct answers - I did manually in column P as service - the formula I applied in column N I can’t able to apply full excel sorry mage is too sorry i

Yes there are always be third \ as well. Few worked and rest didn’t :) but anyways you’re rock ⭐️

Hello team need help in getting the string after two slashes in the below path - I mean need get the keyword of ‘Microsoft SQL server’ plug-in output: path : C:\Program Files\Microsoft SQL Server\150\DT I have hell no of rows and my mid function is not working well :( can anyone explain...

Thank you so much chirayu GraH - Guido Appreciated for quick response and help!

Hi Marc L Please see attached file - with the Expected columns on the right side and Column A is actual data..

Hi I’m not sure about code. Could you suggest anything on this

Alan I tried it but it’s j not working if it has a multiple commas eg: if it has mailing street line 3 and it’s skipping the city and then postcode

Hellow people, Can someone show me light on how to format Mobile and Phone numbers Column A & B Please see attached The red coloured ones are incorrect format so need be splitted into 0422 567 345(Mobile number) and Phone should be formatted into 02 5678 3456(Phone) Please help!!

Also if anyone can suggest me with formula that would be greatly appreciated.

Hello Techie peeps, I have a problem to split the Mailing address(dummy ones) into Street1, street2, street3, Suburb, State, Postcode, Country.. The address is in column A(red colour) and I need the format in left side columns.... Can you please suggest me to format accordingly... Thanks

It can be a valid alternative or else we can do like keeping R's constant and fine tune combinations of M and F's.. Is that possible?

Hello Wonderful Excel Ninjas, Would anyone be able to try to find out Excel combinations for this scenario, attached looking for combination of CELL A with cell B, C, D FOR Eg looking like R1M1F1 R2M2F2 R3M3F3 R1M3F3 R2M1F1 R3M2F2 R1M2F2 R2M3F3 R3M1F1 Something like that... can you please...

vlookup (match on DA Number) to override the current incorrect data values in accounts tab with the correct ones in Sheet1, namely G and H I tried the formula but its not working. Please see attached.

@Haz Excellent! Its working fine!! thankuuu

Thanks @Haz Will try this and let you know,, I think for this scenario if First name is "George." it displayed as Supporter - it should be "George." only because its length is <3

Hi @bosco_yip 1] I have added Before & After sheet to be in column "H" 2] I have written it and its in Red colour (After sheet) column (26 to 33) 3] For First name (A.M, E.N. , A & N, B & P, B.K ) for all these scenarios output (column H should be "Supporter" ) and for First name Bo, An - it...

@bosco_yip, @cyliyu Any heads-up on this issue guys?

@cyliyu Thank you so much,,it means a lot to me!! appreciated for quick help.. You're a star

Please check the AFTER & Before formula in Excel, I need FULLSALUTATION formula, it should return "Supporter" if column F is FALSE and has a SEGMENT accociated to it. For dots(anamolies), one initial, two initials - it must return "Supporter". Any quick help is appreciated guys... Pls

Hi Freinds, Please check the AFTER & Before formula in Excel, I need FULLSALUTATION formula, it should return "Supporter" if column F is FALSE and has a SEGMENT accociated to it. For dots(anamolies), one initial, two initials - it must return "Supporter". Any quick help is appreciated...

I need the excel formula guys?