Copy and past from e-mail into exccel

[tpkelley_no]

When I copy and paste date from an e-mail into excel, the number are not readable. I have to go into each cell and delete the spaces with the backspace so it can be readable. Do they have an excel formula that can do this for me? The spaces can vary.

 

[PeteWright]

please give me an example of the date format in your email.

 

[tpkelley_no]

Here is a copy of the e-mail:

10/14/2021	776.77
10/14/2021	33,958.15

10/14/21​

776.77​

 

[Michael M]

@tpkelley_no
Is post #3 how it looks in the email or how it looks in EXcel ??
If it's in Excel tyr highlight the column and change the alignment, ie, left justified, center, etc
If they really are spaces and not non printing characters, try running this code after the data is copied from email

Sub MM1()
Dim rng As Range
Set rng = ActiveSheet.UsedRange
Application.ScreenUpdating = False
With rng
    .Value = Evaluate(Replace("If(@="""","""",Trim(@))", "@", .Address))
End With
Application.ScreenUpdating = True
End Sub

 

[tpkelley_no]

Thank You

 

[Michael M]

Glad to help ?