Hello
I am not sure if Excel is the best package to use for this, but I think so...
I have an iPhone and have downloaded all my SMS messages into a .TXT file and looks like this:
From Ben Skart at Nov 22, 2008 23:15 :
You got a spare ticket for oasis? Mate of mine would cut a nut off for a ticket.
Send To Ben Skart at Nov 22, 2008 23:41 :
Sorry I don't have this number? But yes I think I may have a spare one!
From Ben Skart at Nov 22, 2008 23:42 :
Its ben, Claire's boyfriend.
Send To Ben Skart at Nov 22, 2008 23:44 :
Ah right! Sorry man, didn't save your number. Yeah I might have one but probably won't know until the tickets get sent out.
What I want to do is have it on my screen like an iPhone conversation: Messages I've sent on Column B in Green and Received in Grey on Col A.
However there are 1000s of these messages and they don't always take up a single line and something there is a carriage return and then more message. Sometimes he replies and then sends another message before I have so its not SENT/RECEIVED/SENT/RECEIVED kind of strict order.
I hope this makes sense! I'm thinking conditional formatting will help
THanks
Routeski
I am not sure if Excel is the best package to use for this, but I think so...
I have an iPhone and have downloaded all my SMS messages into a .TXT file and looks like this:
From Ben Skart at Nov 22, 2008 23:15 :
You got a spare ticket for oasis? Mate of mine would cut a nut off for a ticket.
Send To Ben Skart at Nov 22, 2008 23:41 :
Sorry I don't have this number? But yes I think I may have a spare one!
From Ben Skart at Nov 22, 2008 23:42 :
Its ben, Claire's boyfriend.
Send To Ben Skart at Nov 22, 2008 23:44 :
Ah right! Sorry man, didn't save your number. Yeah I might have one but probably won't know until the tickets get sent out.
What I want to do is have it on my screen like an iPhone conversation: Messages I've sent on Column B in Green and Received in Grey on Col A.
However there are 1000s of these messages and they don't always take up a single line and something there is a carriage return and then more message. Sometimes he replies and then sends another message before I have so its not SENT/RECEIVED/SENT/RECEIVED kind of strict order.
I hope this makes sense! I'm thinking conditional formatting will help
THanks
Routeski