Need to add period last before 3 character

**Sekar G** · 05-30-2020, 01:49 AM

I need to insert the period before the last 3
character always. Please help me.

123456789 to 123456.789
12345678 to 12345.678
12345 to 12.345
12ABC1 to 12A.BC1

and so on.

**Kaper** · 05-30-2020, 01:54 AM

use such formula:

Formula:

Please Login or Register  to view this content.

instead of A1 use the adres of the data cell

**Sekar G** · 05-30-2020, 01:59 AM

Thank you. Now this working.

Need to add period last before 3 character

LinkBack

Thread Tools

Rate This Thread

Display

Need to add period last before 3 character

Re: Need to add period last before 3 character

Re: Need to add period last before 3 character

Thread Information

Users Browsing this Thread

Similar Threads

Want to have the average of requests per customers for a give period versus another period

[SOLVED] Calculate the portion of a planned number during a period, based on another time period

[SOLVED] How to delete last character if it's a period

[SOLVED] add period after last character in cell range

[SOLVED] Find dot/period with 1 or 2 spaces and capitalize the next character/letter

How to sum when it exceeds limits and calculate the period (payback period)

[SOLVED] Complicated:Calculate time period based on no. of units sold + fluctuations within period

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions