ExcelBanter - Change Text

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

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

- - Change Text (https://www.excelbanter.com/excel-discussion-misc-queries/14952-change-text.html)

gregork

Change Text

In Cell A1 I have two types of text: 5/3 or 15/2
In Cell A2 I want a formula that changes the A1 text to 053 or 152.

Cheers
GK

Max

Try in A2: =TEXT(SUBSTITUTE(A1,"/",""),"000")

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"gregork" wrote in message
...
In Cell A1 I have two types of text: 5/3 or 15/2
In Cell A2 I want a formula that changes the A1 text to 053 or 152.

Cheers
GK

gregork

Thanks for your solution Max.

regards
GK

"Max" wrote in message
...
Try in A2: =TEXT(SUBSTITUTE(A1,"/",""),"000")

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"gregork" wrote in message
...
In Cell A1 I have two types of text: 5/3 or 15/2
In Cell A2 I want a formula that changes the A1 text to 053 or 152.

Cheers
GK

Max

You're welcome !
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"gregork" wrote in message
...
Thanks for your solution Max.

regards
GK

All times are GMT +1. The time now is 10:03 PM.