splitting a cell in to three
Thankyou veyr much :)
"James" wrote:
Hi
You can use a mid formula so if your cell shows as 01,03,2009:
Mid(A1,4,2)
4 is the character your want to start with from the left i.e. 0 and the 2 is
number of characters you want i.e 0 & 3.
--
James.
"RowzeRiot" wrote:
i have a list of dates 'DD,MM,YYYY' and i need to split the cells so that in
a new collum it has 'DD' 'MM' 'YYYY' i can understand how to put the day and
year into a new collum =left(A1,2) & =right(A1,4) but i cant work out how to
seperate the middle
should i delete the commas?
thanks in advance
Rose
|