Forum Discussion
Formula or Function
I am needing to know if it is possible in Excel to search a column of data and pull a section of that data if it matches certain rules and have it copied into another column. example in my spreadsh...
yes this is a row of my data it has the date in one column next column is blank and 3rd is the column that i need to pull the part that has the VN#...... is what i need to copy or move to the 2nd column that is blank . However every row in the 3rd column is different but every row contains the VN#....
21 Apr 2022 Credit Acceptance Corp - 2015 Chrysler 200 Gray VN#538798
04 Aug 2022 WISEROADS - 1998 Dodge Ram VN#190748 (TI)
20 Dec 2022 Accelerating the Future Auto Sales - 2007 Ford F150 VN#D74721 (TI)
21 Apr 2022 Credit Acceptance Corp - 2015 Chrysler 200 Gray VN#538798
04 Aug 2022 WISEROADS - 1998 Dodge Ram VN#190748 (TI)
20 Dec 2022 Accelerating the Future Auto Sales - 2007 Ford F150 VN#D74721 (TI)
Thanks, but please see my previous reply.