Date Format Problem

[marableg]

Hello,

I am trying to create a fromula that adds a space before the last two characters in a cell. The format is currently:

1/1 1:17PM.

I am looking to convert this to

1/1 1:17 PM.

Any help anyone can give would be great.

 

[Warship]

=left(a1,len(a1)-2) & " " & right(a1,2)

 

[Scott Huish]

=replace(a1,len(a1)-1,0," ")

Note that I'm assuming per your description that the . is not actually in the cell value.

 

[marableg]

Yes. That is correct. I used Warship's method and it worked perfectly. Thanks guys for all of your help.