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
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