Help Please custom formating cells

LgoSheeps

New member
Joined
Nov 25, 2021
Messages
1
Reaction score
0
Points
0
Excel Version(s)
windows 10
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.
 
Back
Top