adding a character to all cells in one column

[winifred]

I have a column full of number like this:
2985936
234562
69863

What I need to do is add a '-' between the last and the second last
character, like this.
298593-6

Does anyone have suggestions about how to do this? :/

 

[Frank Kabel]

Hi
in a helper column enter a formula like
=LEFT(A1,LEN(A1-1) & "-" & RIGHT(A1,1)

 

[Don Guillett]

try
Sub adddash()
For Each c In Selection
c.Value = Left(c, Len(c) - 1) & "-" & Right(c, 1)
Next
End Sub

 

[Don Guillett]

maybe

LEN(A1-1)

should be
LEN(A1) -1

 

[Ron Rosenfeld]

I have a column full of number like this:
2985936
234562
69863

What I need to do is add a '-' between the last and the second last
character, like this.
298593-6

Does anyone have suggestions about how to do this? :/

You could use the custom format 0-0.
Format/Cells/Number Custom Type: 0-0

Or, if you wanted to convert the number to text:

=TEXT(A1,"0-0")


--ron

 

[Harlan Grove]

You could use the custom format 0-0.

....

Very clever.

 

[Ron Rosenfeld]

...

Very clever.

Thanks. In this group, it's often difficult to come up with something that is
both unique and useful


--ron