ExcelBanter - Insert spaces in String of Numbers

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Insert spaces in String of Numbers (https://www.excelbanter.com/excel-worksheet-functions/107121-insert-spaces-string-numbers.html)

Marianne

Insert spaces in String of Numbers

Hello, I have a series of 16 numbers and would like to insert spaces or
dashes. Is there a formula that can be used to accomplish this task. My
number appears from the report as: pp234567890123. I would like
pp2-345-678901-23. Thanks for your time.

Don Guillett

Insert spaces in String of Numbers

Use the LEFT, MID and RIGHT functions
=left(a2,3)&"-"&mid(etc

--
Don Guillett
SalesAid Software

"Marianne" wrote in message
...
Hello, I have a series of 16 numbers and would like to insert spaces or
dashes. Is there a formula that can be used to accomplish this task. My
number appears from the report as: pp234567890123. I would like
pp2-345-678901-23. Thanks for your time.

All times are GMT +1. The time now is 05:57 PM.