Simple stuff (Probably)

C

ChrisMattock

Hey all,

Just need some quick help, need to have a cell show this....

GAP/06/21300

Where...

GAP comes from Cell A1

06 comes from Cell A2 (Currently I'm using "=year(now())", but tht
gives 2006, not 06)

21300 comes from A3

Optimisticly tried =A1,"/",A2,"/",A3, obvioulsy didn't work, Im not
great at this btw!
 
D

Dav

Try

=A1&"/"&RIGHT(A2,2)&"/"&A3 if a2 contains 2006

or

==A1&"/"&TEXT(A2,"yy")&"/"&A3 if a2 contains a date

Regards

Da
 
C

ChrisMattock

Thanks guys, that's brilliant, now how about if I want the next bit to
be the initials of someones name? i.e. cell A4 has Chris Mattock, and I
need to get CM?
 
A

aidan.heritage

Is it always going to be first name SPACE second name - if so, use
LEFT(CellRef,1) to get the first initial and MID(CellRef,search("
",CellRef)+1,1) to get the second initial
 
T

Toppers

=LEFT(A4,1) & MID(A4,FIND(" ",A4,1)+1,1)

will get initials assuming only first and last name present separated by one
blank.

HTH
 
Top