Move text from end of cell to beginning

[q1911]

Hello-

When I import data from a site into excel, negative percents show up as .1- instead of -.1

Is there any way to have a macro move the - from the end to the start of the cell.

There are other cells in the sheet that have the - in the beginning.

Thanks!

 

[Jonmo1]

Welcome to the board..

Try highlighting the column of data
Data - Text to Columns
Deliminated - Next
Uncheck all options - Next
Click Advainced
Check "Trailing minus for negative numbers" - OK
Finish

 

[ZAX]

Hi,

I hope The Code Will Help You.

Sub Check()
For Each Cell In Range("a1:az" & Cells.End(xlDown).Row)
If InStr(1, Cell.Value, "-") > 0 Then
Cell.Value = "-" & Left(Cell.Value, Len(Cell.Value) - 1)
End If
Next
End Sub

ZAX

 

[q1911]

Welcome to the board..

Try highlighting the column of data
Data - Text to Columns
Deliminated - Next
Uncheck all options - Next
Click Advainced
Check "Trailing minus for negative numbers" - OK
Finish

Thank you. Recorded that as a macro and it worked perfect.

Thanks for the replies!

 

[Jonmo1]

Glad to help, thanks for the feedback.