Pasting table from Outlook email to Excel spreadsheet

[denver1717]

How do I copy a table that was pasted to an Outlook email to Excel and either make the values paste as numbers, or else convert the pasted values to numbers?

The table from Outlook comes over with random spacing at the beginning and end of each number contained in a cell. Finding and replacing the blank spaces doesn't work. I literally am having to go into each cell in excel and remove the spacing before and after the number to get the number to register as a number.

Converting the data as text to columns works sometimes, but a lot of the times there is a different number of blank spaces before and/or after the number in each cell of the column.

Thank you for any help!

[ChemistB]

Finding and replacing the blank spaces doesn't work

What exactly do you mean by that? Do the spaces not disappear? or does it just not automatically convert to a number?

If the second, (all spaces are gone), then simply select the column, click on "Text to Columns" and click "Finish"

If the first, then they are not normal spaces. You can copy one of them and paste it into the FIND field in Find n Replace Window to remove those spaces.

Did that help? We could also do a lot of TRIM and CLEAN formulas but you'd need to update an example spreadsheet to help with that. I think the first options are easier.

[denver1717]

I wish I could post the table the way it looks in the Outlook. ChemistB, searching on the actual spacing helped in that I didn't have to go into each individual cell and delete the spacing (it'd be nice if the spacing was consistent, instead I have to keep adjusting the spacing in the find and replace because it varies). Once I get the spaces all out of the cell (before and after the number) they convert to a number, which is my goal. I was hopeful there was a formula that removes all blanks in a cell regardless of how many there are (in front of and after a number). I have never heard of region settings. Thanks again for your help

below is the table but it doesn't really do much since you can't see the format/spacing
2015 Actual Monthly Guilderland Rehab Latham Saratoga Rotterdam Central Second Cohoes Halfway House
YTD As of Month End Date
Jul ******** 839 845 ******** 878 *********854 *********982 **********935 *********909 *********681
Aug ***** 1,861 ******1,814 ******1,914 ******1,821 ******2,003 *******2,002 ******1,915 *********661
Sep ***** 2,875 ******2,783 ******2,890 ******2,690 ******3,141 *******3,118 ******2,882 *********656
Oct ***** 3,789 ******4,100 ******4,166 ******3,942 ******4,713 *******4,706 ******4,095 *********651
Nov ***** 4,657 ******5,122 ******5,314 ******5,081 ******6,187 *******6,049 ******5,103 *********619
Dec ***** 5,458 ******6,250 ******6,551 ******6,358 ******7,735 *******7,688 ******6,367 *********652
Jan ***** 6,206 ******6,924 ******7,274 ******7,227 ******8,700 *******8,581 ******7,275 *********665
Feb ***** 6,911 ******7,682 ******8,046 ******8,199 ******9,777 *******9,649 ******8,246 *********606
Mar ***** 7,697 ******8,723 ******9,227 ******9,453 *****11,262 *****11,095 ******9,688 *********599
Apr ***** 8,404 ******9,529 *****10,139 *****10,400 *****12,497 *****12,213 *****10,814 *********625
May ***** 9,155 *****10,374 *****11,127 *****11,492 *****13,851 *****13,307 *****11,920 *********675
Jun **** 11,518 *****12,340 *****12,818 *****15,556 *****14,740 *****13,307 *********619