Reply With Quote
It probably best to alter how the data is imported from the csv file.
How are you currently doing it?
What version of Excel are you using?
What decides where to split UK123456712345
Could you attach a csv file here (you may have to zip it first)?
Please could someone help me custom format my cells. I have tried copying what is said online and don't seem to be able to get it to work.
My Data is coming in as UK123456712345 when I import it from the reader (CSV FILE).
and I would like to have it looking like UK1234567 12345
Is there a way to custom format the cells to do this I have 1000s of lines of data and it will take forever to get through doing it manually.
TIA
Lou
It probably best to alter how the data is imported from the csv file.
How are you currently doing it?
What version of Excel are you using?
What decides where to split UK123456712345
Could you attach a csv file here (you may have to zip it first)?
If you can't change the source data, it is a simple VBA task, or maybe Power Query.
Posting Permissions
Bookmarks