Return a different date format

  • Thread starter Thread starter david.jordan1
  • Start date Start date
D

david.jordan1

Hi
Can anyone help me with this?

What i want to do is to take part of two dates and ,a name and combine
them into a string.
In other words,I want to take the day and month from column A
(3101)and B (2410) and the first 4 letters from A (Main) to produce
the invoice no D (31012401 Main)
A B
C D

Site From
To Invoice no.

Main St 31-Jan-08 24-Oct-07 31012401 Main


I would be most grateful for suggestions.
thanks
David
 
Trying to guess which columns you really intended, rather than what you said
below, and assuming that where you have 2401 twice you intended 2410, then
perhaps try:
=TEXT(B2,"ddmm")&TEXT(C2,"ddmm ")&LEFT(A2,4)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Populate Data from a table to another 0
Blank date column return datel 00-Jan-00 4
Vlookup with Dates 0
to CONCATENATE from the smallest date with at least 2 criteria 17
sumif 2
How to determine the value? 1
Date Function 1
2 dimensional date sort 1

Back
Top