Truncating a String

[OcMac]

Hey all,

I am trying to write some code to take information in a cell and only store part of it to be used later in another cell.

So A1 for example has Mr Disney, Walt, I would like to only store Disney, Walt.

then in B2 is DL2458/MSY/11-may-13 12:29 the only part i would like to keep is the 12:29

Any thoughts?

Thank you,

Matt

[stnkynts]

The trick with doing something like this finding the common factor (there has to be one) which you can use to separate out the parts you want. From your two examples it appears that you want to keep everything after the first space. Is this correct?

[scott.s.fower]

Please Login or Register  to view this content.

where Strng = the location of the text string ie B2 in your example
tm is time (because you are looking at a time, you can change that if you wish)
nm is name (because you are extracting a name) - it doesn't matter if it is Mr, Mr. or M, but if it is just Disney, Walt or D., Walt then it will only give you Walt
you would prob do some sort of loop i'm guessing

[OcMac]

Hey guys thank you for your help.

In the first example, I would want to remove everything before the first space. On the second example I would like remove everything up to the last space. Can the be done from left or right?

Thank you for your help,