I scanned in a document and it added two columns of information into one (date and name are both in the same column) how can I take the date out of this column and move it to a different one with multiple cells at one time.
I scanned in a document and it added two columns of information into one (date and name are both in the same column) how can I take the date out of this column and move it to a different one with multiple cells at one time.
Can you show some samples and where to split?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Hi and welcome in the forum
Your Data in A1.
In B1>>=0+LEFT(A1;COUNT(LEFT(A1;COLUMN($1:$1))*1))
In C1>>=TRIM(MID(A1;MAX(ISNUMBER(MID(A1;COLUMN(1:1);1)*1)*COLUMN(1:1))+1;2^15))
Both of these, are Arrays Formulae.(C+S+E),not just Enter.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Text to Columns is likely to be what you need but you need to post a sample.
here is an example I have a list of cars and the year and make of each one are in the same column D.
and how do I run a forumula or script on the spreadsheet? never done that before
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks