have been asked to transfer XERO to SAGE data
XERO pl + sl do not have any defaul t account 'A/C' field - as required by SAGE just the account name
so export from xero contact details
so in excel thinking was...
insert new column[A/c} then copy Name to A/C [Account name] .......then within excel shorten the A/C field....it is this which I am wondering how to effect eg from XERO NAME = PETER SMITH INDUSTIRES PTY, into csv in excel- then copy this to a new column = A/c and shorten to PETERSMI
now hopefully 2 different fields to upload on to SAGE via the template uploader
is there another way/ better way plse
and yes it has to be xero>sage!!!