Hi, belated HNY to all!
My steps are as follows:
Copy pdf and paste into word > convert text to table
I hope someone can help...since the pdf field has combined text and numbers it is coming into excel the same.
Is there something I can do in the import wizard so that the text and numbers can go into separate fields.
Attachment shows problem. If there is a way kindly give easy steps!
Many thanks for looking
You can use this formula to separate numbers from text
=--SUBSTITUTE(A1,LEFT(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&1234567890))-1),"")
Row\Col GOODSTOTAL2,304.00 VATTOTAL460.80 INVOICETOTAL27640.80
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Brilliant - many thanks. I have added to your reputation!
=right(a1,8)
Thanks - nice and short. Please advise what the 8 does?
The RIGHT will extract from a string starting from the right the number of characters. In this case it is 8. It is a very useful function along with other text functions such as LEFT, MID, SUBSTITUTE and REPLACE. However, it is important to know that text functions will return values as text. It is best used when you need to extract characters from the right. However, it may prove to be less practical to use it when the number of characters changes with each row.Originally Posted by Shreyans Nahata
Try this:
=REPLACE(A1,1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))-1,"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks