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?

[Webinar] Streamline your web hosting managementRegister Today

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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
All Courses

From novice to tech pro — start learning today.