Kevin Anthony Oppegaard Rose
Reputation
255
Top tag
Next privilege 300 Rep.
Create new tags
Badges
1 8
Newest
 Student
Impact
~18k people reached

  • 0 posts edited
  • 0 helpful flags
  • 64 votes cast
Feb
6
comment Excel find specific number of characters
As duDE said, your question is not clear. I am assuming you mean you want to find some string in a cell where that is not the only string? For example, a cell contains "123456789" and you want to find "456", of this is the case then using a filter will work. However I do not understand the "the numbers are not the same .... so I can't Ctrl F" bit, surely you can just change the value you are searching for?
Feb
4
accepted How can I combine two lists into one long list?
Feb
4
comment How can I combine two lists into one long list?
The IF statement is exactly what I needed. Thank you, this will save me hours in future work :)
Feb
4
awarded  Student
Feb
4
comment How can I combine two lists into one long list?
It will have 10x15 rows :)
Feb
4
comment How can I combine two lists into one long list?
I dont think either of them are applicable. I have two coloumns of data which I need to combine as above.
Feb
4
asked How can I combine two lists into one long list?
Jan
31
awarded  Yearling
Dec
12
comment Merge two cells “AAA” and “001” to get “AAA-001”?
Perfect. I knew what the problem was but just could not solve it, using "000" as the format for the text worked perfectly. TY so much, you just saved me maybe 20 hours work over the next few months :)
Dec
12
accepted Merge two cells “AAA” and “001” to get “AAA-001”?
Dec
12
comment Merge two cells “AAA” and “001” to get “AAA-001”?
Unfortunatly the 001 is gathered from an outside sorce and copied into place as 1 therefor converting it to text using ' will not help be a massive time sink and I might as well leave it as 001 and compare the two by eye. Thank you for your answer though.
Dec
12
asked Merge two cells “AAA” and “001” to get “AAA-001”?
Aug
15
comment Strange, extra lines in images in .pdf saved with MS Word (happens with images from R and possibly other images)
@Wally Printing to PDF could work, however when dealing with large documents saving to PDF also gives you the option to automatically create bookmarks which can save hours of work.
Aug
15
comment Excel - how to merge columns of data from consecutive rows?
@User2646560 if this answered your question you should mark it as the answer.
Aug
15
comment Is it possible to split text over two lines in MS Word
I personally feel it is the easiest but the term easiest is very personal. Whats easiest for me is difficult for someone else and a waste of time for someone else. Reworded my answer accordingly :)
Aug
15
revised Is it possible to split text over two lines in MS Word
deleted 8 characters in body
Aug
13
answered Is it possible to split text over two lines in MS Word
Jun
12
awarded  Scholar
Jun
12
accepted Can I use a cmd command to move previous revisions of documents into a different folder?
Jun
11
comment Can I use a cmd command to move previous revisions of documents into a different folder?
Thank you for your answer. I will check first thing tomorrow morning and mark as excepted answer if it works, but +1 for such a detailed answer :)