Hi everyone, OK to the point. I need to pull a part number from a spreadsheet which had 517 incidence's. They all start the same way (FC) and then have an 8 digit wild card. I need to move them from the column that they are all in to another column, but they are not the only text with in the present column so just copy and paste will not work. Any ideas?
One way
In 1st row of another column put this formula (change A1 as required)
=IF(LEFT(A1,2)="fb",A1,"")
Copy formula down column as far as required
If you want to change the formula to values
Copy Column with formula
Use PasteSpecial > Values paste the column back into the same column
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks