left function

Hi,

Attached i have a ss

Go to sheet "Cash Nostro"

You can see where my formula lets me down, ive highlighted in red.

It is due to the length of the user name

I need a solution for this but im not 100% sure what to do and am looking for suggestions

Thanks
Seamus
Call-Latest-File.xls
Seamus2626Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rory ArchibaldConnect With a Mentor Commented:
I'd suggest you sort out however you parse the data into columns in the first place. :)
0
 
telyni19Connect With a Mentor Commented:
It looks like you're pulling the first eight characters, whatever they are, into the first column. You probably need to split it out up to the first space instead. I looked through the code a bit and didn't see where you were getting the data though.
0
 
wchhCommented:
Try Formula below:
=IF(D27="No",IF(ISERROR(DAY(C27)),IF(ISERROR(SEARCH("t ",C27)),DATEVALUE(CONCATENATE(RIGHT(B27,LEN(B27)-SEARCH("t ",B27)-4),C27)),DATEVALUE(MID(C27,SEARCH("t ",C27)+2,LEN(C27)-SEARCH("t ",C27)))),C27),"")
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
wchhCommented:
Make sure that your computer date format is 'dd/mm/yyyy'
0
 
wchhCommented:
Try Formula below fot time column:
=IF(D27="No",IF(ISERROR(DAY(C27)),IF(ISERROR(SEARCH("t ",C27)),TIMEVALUE(CONCATENATE(RIGHT(B27,LEN(B27)-SEARCH("t ",B27)-4),C27)),TIMEVALUE(MID(C27,SEARCH("t ",C27)+2,LEN(C27)-SEARCH("t ",C27)))),C27),"")
0
 
Seamus2626Author Commented:
The formulas didnt work guys

Thanks
Seamus
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.