Example:
A1 = 02/15/11
A2 = 1,252,893.58
A3 = 021511125289358
Is it possible to take the numbers of a date in one cell and the numbers of a dollar amount in another cell and combine them into a 3rd cell without the dashes, commas, and periods?
Thanks
Bookmarks