1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

help separate numbers from Dates in a column.

I have a column with Dates, words and numbers. I need to pull just the dates off of sheet1 and insert them on sheet2. I have been able to get them but it also converts all the numbers to dates. Not sure what function I need to be using.

submitted by /u/Common-Vacation4877
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#dates
#numbers
#column
#function
#Excel
#sheet1
#sheet2
#pull
#insert
#formula
#spreadsheet
#convert
#data extraction
#data manipulation
#words
#operation