Lo All o/
Been a lil while. I am trying to pull out an invoice number (Varies in character length) w/in a comment that is entered into our ledger. I have attached a screenshot of what we're trying to pull out and attached a sample file.
Any help, if it's possible, is greatly appreciated.
PullValues.png
Hi!
You could try:
[H3] : =TRIM(MID(SUBSTITUTE(G3," ",REPT(" ",50)),100,50))
And drag it down. Blessings!
I agree with Johnmpl,
See if this works for you.
PullOutValues blow up spaces.xlsx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Worked. Mucho gracias. How are you determining to use the 50/100 values? For instance, how would I determine which values to enter to grab, say, these values:Originally Posted by johnmpl
PullValues2.png
Last edited by Miskondukt; 02-21-2018 at 11:46 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks