Without seeing your data it's hard to say?



Can you post some sample data?

it looks like this....

john 9:00 doe
jane 6:00 doe

I want it to look like this...

9:00 john doe
6:00 jane doe


is there something I can do, since it's a big document. it would take a long time to do it manually.

A quick method would be
Data - Text to columns - Delimited - use space as delimiters - Make sure you set the format to text for the second columns in the next screen - Finish
You now have each string in three columns say B C and D
n E enter =C1&" "&B1&" "&D1&" "

Pull down as needed

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post