ExcelBanter - replacing comma with another symbol

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - replacing comma with another symbol (https://www.excelbanter.com/excel-discussion-misc-queries/143595-replacing-comma-another-symbol.html)

FreddieP

replacing comma with another symbol

Hi I have a column of figures like

21,95
15,50
26,45

I would like to replace the comma and instead show

21:95
15:50
26:45

I have tried to convert it to text and replace the comma but it doesn't work.

Can anybody help me please?

Regards Freddie

Mike H

replacing comma with another symbol

Assuming data is in A1 down, put this in B1 and drag down.

=SUBSTITUTE(A1,",",":")

Mike

"FreddieP" wrote:

Hi I have a column of figures like

21,95
15,50
26,45

I would like to replace the comma and instead show

21:95
15:50
26:45

I have tried to convert it to text and replace the comma but it doesn't work.

Can anybody help me please?

Regards Freddie

ToddEZ

replacing comma with another symbol

try find and replace

"Mike H" wrote:

Assuming data is in A1 down, put this in B1 and drag down.

=SUBSTITUTE(A1,",",":")

Mike

"FreddieP" wrote:

Hi I have a column of figures like

21,95
15,50
26,45

I would like to replace the comma and instead show

21:95
15:50
26:45

I have tried to convert it to text and replace the comma but it doesn't work.

Can anybody help me please?

Regards Freddie

All times are GMT +1. The time now is 10:32 AM.