Help required :removal of garbage characters from cell

The cells contain words with alphapets and numbers and also the . symbol. But many of them contain junk characters . i need to formula to ( able to remove all junk characters from cell. Please share the same

example of data

djhsjdh3536 garbage
dsdswjdjkwe2 garbage
dwsjdhwd


Need the garbage removed from the cell and only letters, numbers and the dot symbol should remain

i also have some cells example where the garbage value starts with [ and there are letters and numbers

example

hello [13bhne
newguy [5363fdgh



Output should be

hello
newguy

please help remove the garbage hereaswell

Your examples do not adequately show how your data is setup. There is no "." in any of your examples

Hi mcmahot, the . is a valid character . i have not included it in above examples.

I just need to be able to eliminate everything except the 26 letter and 10 digits and the . symbol

You can create workbook using the examples i provided .


djhsjdh3536 garbage
dsdswjdjkwe2 garbage

mcmahobt , I really appreciate you trying to help me but I am really sorry I cant share restricted information on a public forum

I havent asked for my work to be done , all i need is a simple formula to remove all garbage values( anything that is not a letter, number, or the . symbol) from a cell

You can see garbages below . This can be even characters from another language or some rubbish and gibberish . Just want them eliminated

djhsjdh3536 ^*({#
dsdswjdjkwe2 !^&%