ExcelBanter - Substring to replace string

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Substring to replace string (https://www.excelbanter.com/excel-programming/301203-substring-replace-string.html)

Andrew Slentz[_2_]

Substring to replace string

Andrew

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Frank Kabel

Substring to replace string

Hi
try something like

with activesheet.range("A1")
.value = left(.value,5)
end with

--
Regards
Frank Kabel
Frankfurt, Germany

Andrew Slentz wrote:
Andrew

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

All times are GMT +1. The time now is 09:46 AM.