Problems with formatting text within a cell.

New Contributor

I am trying to take a location number ( example L4027) and have it appear in the cell as L4-027. Is there a formula that I could use to do this? 

3 Replies



The text is in cell A1. Formula in B1:


Wow! Thank you for showing me this. If I had one more cell similar to the previous question. Example - L4037B and I wanted it to appear as L4-037-B, using the previous equation leaves the B as this L4-037B. Is there another command that I need to place into the equation? 


Then it would be:

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies