Insert the space character in the penultimate place of all the cells of columns "A" - "B" & "C".

harzer

Board Regular
Joined
Dec 15, 2021
Messages
153
Office Version
  1. 2016
Platform
  1. Windows
Hello everyone,
My data is in columns: "A", "B", "C", "D", "E", "F", "G", "H", "I", "J" and "K" ".
The data on which my code works is the first three columns: "A", "B" and "C".
What does this code do?
This code inserts the space character (" "), in all the cells of the columns: "A", "B" and "C". It inserts precisely this character (" "), in the penultimate place of all column cells: "A", "B" and "C".
Sure, the code does the job well, but it has a problem, and that's that it's not fast.
I think i need to use arrays to make it fast.

So here is the code:

VBA Code:
Sub Insert_Space()

    Dim SrchRng As Range        'this code allows to insert a space in the penultimate place for each cell of the column "A", "B" & "C"
    Set SrchRng = Range("A2", Cells(Rows.Count, "C").End(xlUp))

    Dim Cel As Range
    For Each Cel In SrchRng
        If InStr(1, Cel.Value) <> "" Then
            Cel.Value = Left$(Cel.Value, Len(Cel.Value) - 1) & " " & Right$(Cel.Value, 1)
        End If
    Next Cel

End sub

start data :

Classeur1
ABCDEFGHIJK
1JeunePèreMèreEleveurAgeVolièreCageNé(e)ToursInformationElevage
2AE27-093/2012MAE27-093/2012MAE27-093/2012MGérard Claude10a 11m 28j2B168-06-20124T
3AE27-094/2012MAE27-094/2012MAE27-094/2012MGérard Claude10a 11m 28j2B168-06-20124T
4AE27-100/2012FAE27-100/2012FAE27-100/2012FGérard Claude10a 11m 26j2B1310-06-20124T
5AE27-059/2013FAE27-059/2013FAE27-059/2013FGérard Claude10a 1m 11j3H1325-04-20134T
6AE27-060/2013MAE27-060/2013MAE27-060/2013MGérard Claude10a 0m 31j5H195-05-20135T
7AE27-084R-10/2013MAE27-084R-10/2013MAE27-084R-10/2013MGérard Claude10a 0m 18j3H118-05-20134T
8AE27-084/2013MAE27-084/2013MAE27-084/2013MGérard Claude10a 0m 17j3H1619-05-20134T
9AE27-085R-12/2013MAE27-085R-12/2013MAE27-085R-12/2013MGérard Claude9a 11m 26j3H1610-06-20134T
10AE27-085/2013MAE27-085/2013MAE27-085/2013MGérard Claude10a 0m 18j5H2118-05-20134T
11AE27-086/2013FAE27-086/2013FAE27-086/2013FGérard Claude9a 11m 9j2B2127-06-20134T
12AE27-087/2013FAE27-087/2013FAE27-087/2013FGérard Claude10a 0m 18j5H2218-05-20134T
13AE27-011/2019FAE27-011/2019FAE27-011/2019FGérard Claude4a 1m 14j4H1122-04-20195T
14AE27-012/2019FAE27-012/2019FAE27-012/2019FGérard Claude4a 1m 14j5H1122-04-20195T
15AE27-013/2019MAE27-013/2019MAE27-013/2019MGérard Claude4a 1m 14j4H122-04-20194T
16AE27-014/2019FAE27-014/2019FAE27-014/2019FGérard Claude4a 1m 16j4H220-04-20194T
17AE27-015/2019MAE27-015/2019MAE27-015/2019MGérard Claude4a 1m 17j4H619-04-20194T
18AE27-017/2019FAE27-017/2019FAE27-017/2019FGérard Claude4a 1m 17j3H619-04-20194T
19AE27-042/2022MAE27-042/2022MAE27-042/2022MGérard Claude0a 11m 18j5H618-06-20224Tx
20AE27-043/2022FAE27-043/2022FAE27-043/2022FGérard Claude0a 11m 18j4H618-06-20224T
21AE27-045/2022MAE27-045/2022MAE27-045/2022MGérard Claude0a 11m 11j5H825-06-20224T
22AE27-046/2022MAE27-046/2022MAE27-046/2022MGérard Claude0a 11m 11j5H825-06-20224T
23AE27-047/2022FAE27-047/2022FAE27-047/2022FGérard Claude0a 11m 11j4H825-06-20224T
24AE27-048/2022FAE27-048/2022FAE27-048/2022FGérard Claude0a 11m 8j4H328-06-20224T
25AE27-049/2022FAE27-049/2022FAE27-049/2022FGérard Claude0a 11m 8j4H328-06-20224T
26AEY27-001/2023MAEY27-001/2023MAEY27-001/2023MGérard Claude0a 1m 11j5H1525-04-20234T
27AEY27-002/2023MAEY27-002/2023MAEY27-002/2023MGérard Claude0a 1m 3j5H111-05-20234T
28AEY27-003/2023MAEY27-003/2023MAEY27-003/2023MGérard Claude0a 0m 31j5H125-05-20234T
29AEY27-004/2023MAEY27-004/2023MAEY27-004/2023MGérard Claude0a 0m 15j5H521-05-20234T
30AEY27-005/2023MAEY27-005/2023MAEY27-005/2023MGérard Claude0a 0m 15j5H521-05-20234T
31AEY27-006/2023MAEY27-006/2023MAEY27-006/2023MGérard Claude0a 0m 15j5H521-05-20234T
32AEY27-007/2023MAEY27-007/2023MAEY27-007/2023MGérard Claude0a 0m 15j5H521-05-20234T
33AEY27-008/2023MAEY27-008/2023MAEY27-008/2023MGérard Claude0a 0m 15j5H521-05-20234T
34AEY27-009/2023FAEY27-009/2023FAEY27-009/2023FGérard Claude0a 0m 14j4B622-05-20234T
35AEY27-010/2023FAEY27-010/2023FAEY27-010/2023FGérard Claude0a 0m 14j4B622-05-20234T
36AEY27-011/2023FAEY27-011/2023FAEY27-011/2023FGérard Claude0a 0m 14j4B622-05-20234T
37AEY27-012/2023MAEY27-012/2023MAEY27-012/2023MGérard Claude0a 0m 13j5H1323-05-20234T
38AEY27-013/2023MAEY27-013/2023MAEY27-013/2023MGérard Claude0a 0m 13j5H1323-05-20234T
39AEY27-014/2023FAEY27-014/2023FAEY27-014/2023FGérard Claude0a 0m 13j4B1323-05-20234T
40AEY27-015/2023FAEY27-015/2023FAEY27-015/2023FGérard Claude0a 0m 11j4B725-05-20234T
41AEY27-016/2023FAEY27-016/2023FAEY27-016/2023FGérard Claude0a 1m 11j4B1525-04-20234T
42AEY27-017/2023MAEY27-017/2023MAEY27-017/2023MGérard Claude0a 1m 3j5H111-05-20234T
43AEY27-018/2023MAEY27-018/2023MAEY27-018/2023MGérard Claude0a 0m 31j5H125-05-20234T
44AEY27-019/2023FAEY27-019/2023FAEY27-019/2023FGérard Claude0a 0m 15j4B521-05-20234T
45AEY27-020/2023MAEY27-020/2023MAEY27-020/2023MGérard Claude0a 0m 15j5H521-05-20234T
46AEY27-021/2023FAEY27-021/2023FAEY27-021/2023FGérard Claude0a 0m 15j4B521-05-20234T
47AEY27-022/2023MAEY27-022/2023MAEY27-022/2023MGérard Claude0a 0m 15j5H521-05-20234T
48AEY27-023/2023MAEY27-023/2023MAEY27-023/2023MGérard Claude0a 0m 15j5H521-05-20234T
49AEY27-024/2023MAEY27-024/2023MAEY27-024/2023MGérard Claude0a 0m 14j5H622-05-20234T
50AEY27-025/2023FAEY27-025/2023FAEY27-025/2023FGérard Claude0a 0m 14j4B622-05-20234T
51AEY27-026/2023MAEY27-026/2023MAEY27-026/2023MGérard Claude0a 0m 14j5H622-05-20234T
52AEY27-027/2023MAEY27-027/2023MAEY27-027/2023MGérard Claude0a 0m 13j5H1323-05-20234T
53AEY27-028/2023MAEY27-028/2023MAEY27-028/2023MGérard Claude0a 0m 13j5H1323-05-20234T
54AEY27-029/2023MAEY27-029/2023MAEY27-029/2023MGérard Claude0a 0m 13j5H1323-05-20234T
55AEY27-030/2023MAEY27-030/2023MAEY27-030/2023MGérard Claude0a 0m 11j5H725-05-20234T
56AEY27-031/2023MAEY27-031/2023MAEY27-031/2023MGérard Claude0a 1m 11j5H1525-04-20234T
57AEY27-032/2023MAEY27-032/2023MAEY27-032/2023MGérard Claude0a 1m 3j5H111-05-20234T
58AE27-095/2012FAE27-095/2012FAE27-095/2012FGérard Claude10a 11m 28j4B168-06-20124T
59AE27-096/2012FAE27-096/2012FAE27-096/2012FGérard Claude10a 11m 26j4B1310-06-20124T
60AE27-097/2012MAE27-097/2012MAE27-097/2012MGérard Claude10a 11m 26j5H1310-06-20124T
61AE27-098/2012MAE27-098/2012MAE27-098/2012MGérard Claude10a 11m 26j5H1310-06-20124T
62AE27-099/2012MAE27-099/2012MAE27-099/2012MGérard Claude10a 11m 26j5H1310-06-20124T
63AEY27-038/2023MAEY27-038/2023MAEY27-038/2023MGérard Claude0a 0m 15j5H521-05-20234T
64AEY27-039/2023FAEY27-039/2023FAEY27-039/2023FGérard Claude0a 0m 14j4B622-05-20234T
65AEY27-040/2023FAEY27-040/2023FAEY27-040/2023FGérard Claude0a 0m 14j4B622-05-20234T
66AEY27-041/2023MAEY27-041/2023MAEY27-041/2023MGérard Claude0a 0m 14j5H622-05-20234T
67AEY27-042/2023FAEY27-042/2023FAEY27-042/2023FGérard Claude0a 0m 13j4B1323-05-20234T
68AEY27-043/2023MAEY27-043/2023MAEY27-043/2023MGérard Claude0a 0m 13j5H1323-05-20234T
69AEY27-044/2023MAEY27-044/2023MAEY27-044/2023MGérard Claude0a 0m 13j5H1323-05-20234T
70AEY27-045/2023FAEY27-045/2023FAEY27-045/2023FGérard Claude0a 0m 11j4B725-05-20234T
71AEY27-046/2023FAEY27-046/2023FAEY27-046/2023FGérard Claude0a 1m 11j4B1525-04-20234T
72AEY27-047/2023MAEY27-047/2023MAEY27-047/2023MGérard Claude0a 1m 3j5H111-05-20234T
73AEY27-048/2023FAEY27-048/2023FAEY27-048/2023FGérard Claude4a 1m 14j4B1122-04-20195T
74AEY27-049/2023MAEY27-049/2023MAEY27-049/2023MGérard Claude4a 1m 14j5H1122-04-20195T
75AEY27-050/2023MAEY27-050/2023MAEY27-050/2023MGérard Claude4a 1m 14j5H1122-04-20195T
76AEY27-051/2023FAEY27-051/2023FAEY27-051/2023FGérard Claude4a 1m 14j4B1122-04-20195T
77AEY27-052/2023FAEY27-052/2023FAEY27-052/2023FGérard Claude4a 1m 14j4B122-04-20194T
78AEY27-053/2023FAEY27-053/2023FAEY27-053/2023FGérard Claude4a 1m 16j4B220-04-20194T
79AEY27-054/2023FAEY27-054/2023FAEY27-054/2023FGérard Claude0a 0m 15j4B521-05-20234T
80AEY27-055/2023MAEY27-055/2023MAEY27-055/2023MGérard Claude0a 0m 15j5H521-05-20234T
81AEY27-056/2023MAEY27-056/2023MAEY27-056/2023MGérard Claude0a 0m 15j5H521-05-20234T
82AEY27-057/2023MAEY27-057/2023MAEY27-057/2023MGérard Claude0a 0m 15j5H521-05-20234T
83AEY27-058/2023MAEY27-058/2023MAEY27-058/2023MGérard Claude0a 1m 3j5H111-05-20234T
84AEY27-059/2023FAEY27-059/2023FAEY27-059/2023FGérard Claude0a 0m 31j4B125-05-20234T
85AEY27-060/2023MAEY27-060/2023MAEY27-060/2023MGérard Claude0a 0m 15j5H521-05-20234T
86AEY27-061/2023FAEY27-061/2023FAEY27-061/2023FGérard Claude0a 0m 15j4B521-05-20234T
87AEY27-062/2023MAEY27-062/2023MAEY27-062/2023MGérard Claude0a 0m 15j5H521-05-20234T
88AEY27-063/2023FAEY27-063/2023FAEY27-063/2023FGérard Claude0a 0m 15j4B521-05-20234T
89AEY27-064/2023MAEY27-064/2023MAEY27-064/2023MGérard Claude0a 0m 15j5H521-05-20234T
90AEY27-065/2023FAEY27-065/2023FAEY27-065/2023FGérard Claude0a 0m 14j4B622-05-20234T
91AEY27-066/2023FAEY27-066/2023FAEY27-066/2023FGérard Claude0a 0m 13j4B1323-05-20234T
92AEY27-067/2023FAEY27-067/2023FAEY27-067/2023FGérard Claude0a 0m 13j4B1323-05-20234T
93AEY27-068/2023MAEY27-068/2023MAEY27-068/2023MGérard Claude0a 0m 13j5H1323-05-20234T
94AEY27-069/2023FAEY27-069/2023FAEY27-069/2023FGérard Claude0a 0m 11j4B725-05-20234T
Parents



Here is the desired result :

Classeur1
ABCDEFGHIJK
1JeunePèreMèreEleveurAgeVolièreCageNé(e)ToursInformationElevage
2AE27-093/2012 MAE27-093/2012 MAE27-093/2012 MGérard Claude10a 11m 28j2B168-06-20124T
3AE27-094/2012 MAE27-094/2012 MAE27-094/2012 MGérard Claude10a 11m 28j2B168-06-20124T
4AE27-100/2012 FAE27-100/2012 FAE27-100/2012 FGérard Claude10a 11m 26j2B1310-06-20124T
5AE27-059/2013 FAE27-059/2013 FAE27-059/2013 FGérard Claude10a 1m 11j3H1325-04-20134T
6AE27-060/2013 MAE27-060/2013 MAE27-060/2013 MGérard Claude10a 0m 31j5H195-05-20135T
7AE27-084R-10/2013 MAE27-084R-10/2013 MAE27-084R-10/2013 MGérard Claude10a 0m 18j3H118-05-20134T
8AE27-084/2013 MAE27-084/2013 MAE27-084/2013 MGérard Claude10a 0m 17j3H1619-05-20134T
9AE27-085R-12/2013 MAE27-085R-12/2013 MAE27-085R-12/2013 MGérard Claude9a 11m 26j3H1610-06-20134T
10AE27-085/2013 MAE27-085/2013 MAE27-085/2013 MGérard Claude10a 0m 18j5H2118-05-20134T
11AE27-086/2013 FAE27-086/2013 FAE27-086/2013 FGérard Claude9a 11m 9j2B2127-06-20134T
12AE27-087/2013 FAE27-087/2013 FAE27-087/2013 FGérard Claude10a 0m 18j5H2218-05-20134T
13AE27-011/2019 FAE27-011/2019 FAE27-011/2019 FGérard Claude4a 1m 14j4H1122-04-20195T
14AE27-012/2019 FAE27-012/2019 FAE27-012/2019 FGérard Claude4a 1m 14j5H1122-04-20195T
15AE27-013/2019 MAE27-013/2019 MAE27-013/2019 MGérard Claude4a 1m 14j4H122-04-20194T
16AE27-014/2019 FAE27-014/2019 FAE27-014/2019 FGérard Claude4a 1m 16j4H220-04-20194T
17AE27-015/2019 MAE27-015/2019 MAE27-015/2019 MGérard Claude4a 1m 17j4H619-04-20194T
18AE27-017/2019 FAE27-017/2019 FAE27-017/2019 FGérard Claude4a 1m 17j3H619-04-20194T
19AE27-042/2022 MAE27-042/2022 MAE27-042/2022 MGérard Claude0a 11m 18j5H618-06-20224Tx
20AE27-043/2022 FAE27-043/2022 FAE27-043/2022 FGérard Claude0a 11m 18j4H618-06-20224T
21AE27-045/2022 MAE27-045/2022 MAE27-045/2022 MGérard Claude0a 11m 11j5H825-06-20224T
22AE27-046/2022 MAE27-046/2022 MAE27-046/2022 MGérard Claude0a 11m 11j5H825-06-20224T
23AE27-047/2022 FAE27-047/2022 FAE27-047/2022 FGérard Claude0a 11m 11j4H825-06-20224T
24AE27-048/2022 FAE27-048/2022 FAE27-048/2022 FGérard Claude0a 11m 8j4H328-06-20224T
25AE27-049/2022 FAE27-049/2022 FAE27-049/2022 FGérard Claude0a 11m 8j4H328-06-20224T
26AEY27-001/2023 MAEY27-001/2023 MAEY27-001/2023 MGérard Claude0a 1m 11j5H1525-04-20234T
27AEY27-002/2023 MAEY27-002/2023 MAEY27-002/2023 MGérard Claude0a 1m 3j5H111-05-20234T
28AEY27-003/2023 MAEY27-003/2023 MAEY27-003/2023 MGérard Claude0a 0m 31j5H125-05-20234T
29AEY27-004/2023 MAEY27-004/2023 MAEY27-004/2023 MGérard Claude0a 0m 15j5H521-05-20234T
30AEY27-005/2023 MAEY27-005/2023 MAEY27-005/2023 MGérard Claude0a 0m 15j5H521-05-20234T
31AEY27-006/2023 MAEY27-006/2023 MAEY27-006/2023 MGérard Claude0a 0m 15j5H521-05-20234T
32AEY27-007/2023 MAEY27-007/2023 MAEY27-007/2023 MGérard Claude0a 0m 15j5H521-05-20234T
33AEY27-008/2023 MAEY27-008/2023 MAEY27-008/2023 MGérard Claude0a 0m 15j5H521-05-20234T
34AEY27-009/2023 FAEY27-009/2023 FAEY27-009/2023 FGérard Claude0a 0m 14j4B622-05-20234T
35AEY27-010/2023 FAEY27-010/2023 FAEY27-010/2023 FGérard Claude0a 0m 14j4B622-05-20234T
36AEY27-011/2023 FAEY27-011/2023 FAEY27-011/2023 FGérard Claude0a 0m 14j4B622-05-20234T
37AEY27-012/2023 MAEY27-012/2023 MAEY27-012/2023 MGérard Claude0a 0m 13j5H1323-05-20234T
38AEY27-013/2023 MAEY27-013/2023 MAEY27-013/2023 MGérard Claude0a 0m 13j5H1323-05-20234T
39AEY27-014/2023 FAEY27-014/2023 FAEY27-014/2023 FGérard Claude0a 0m 13j4B1323-05-20234T
40AEY27-015/2023 FAEY27-015/2023 FAEY27-015/2023 FGérard Claude0a 0m 11j4B725-05-20234T
41AEY27-016/2023 FAEY27-016/2023 FAEY27-016/2023 FGérard Claude0a 1m 11j4B1525-04-20234T
42AEY27-017/2023 MAEY27-017/2023 MAEY27-017/2023 MGérard Claude0a 1m 3j5H111-05-20234T
43AEY27-018/2023 MAEY27-018/2023 MAEY27-018/2023 MGérard Claude0a 0m 31j5H125-05-20234T
44AEY27-019/2023 FAEY27-019/2023 FAEY27-019/2023 FGérard Claude0a 0m 15j4B521-05-20234T
45AEY27-020/2023 MAEY27-020/2023 MAEY27-020/2023 MGérard Claude0a 0m 15j5H521-05-20234T
46AEY27-021/2023 FAEY27-021/2023 FAEY27-021/2023 FGérard Claude0a 0m 15j4B521-05-20234T
47AEY27-022/2023 MAEY27-022/2023 MAEY27-022/2023 MGérard Claude0a 0m 15j5H521-05-20234T
48AEY27-023/2023 MAEY27-023/2023 MAEY27-023/2023 MGérard Claude0a 0m 15j5H521-05-20234T
49AEY27-024/2023 MAEY27-024/2023 MAEY27-024/2023 MGérard Claude0a 0m 14j5H622-05-20234T
50AEY27-025/2023 FAEY27-025/2023 FAEY27-025/2023 FGérard Claude0a 0m 14j4B622-05-20234T
51AEY27-026/2023 MAEY27-026/2023 MAEY27-026/2023 MGérard Claude0a 0m 14j5H622-05-20234T
52AEY27-027/2023 MAEY27-027/2023 MAEY27-027/2023 MGérard Claude0a 0m 13j5H1323-05-20234T
53AEY27-028/2023 MAEY27-028/2023 MAEY27-028/2023 MGérard Claude0a 0m 13j5H1323-05-20234T
54AEY27-029/2023 MAEY27-029/2023 MAEY27-029/2023 MGérard Claude0a 0m 13j5H1323-05-20234T
55AEY27-030/2023 MAEY27-030/2023 MAEY27-030/2023 MGérard Claude0a 0m 11j5H725-05-20234T
56AEY27-031/2023 MAEY27-031/2023 MAEY27-031/2023 MGérard Claude0a 1m 11j5H1525-04-20234T
57AEY27-032/2023 MAEY27-032/2023 MAEY27-032/2023 MGérard Claude0a 1m 3j5H111-05-20234T
58AE27-095/2012 FAE27-095/2012 FAE27-095/2012 FGérard Claude10a 11m 28j4B168-06-20124T
59AE27-096/2012 FAE27-096/2012 FAE27-096/2012 FGérard Claude10a 11m 26j4B1310-06-20124T
60AE27-097/2012 MAE27-097/2012 MAE27-097/2012 MGérard Claude10a 11m 26j5H1310-06-20124T
61AE27-098/2012 MAE27-098/2012 MAE27-098/2012 MGérard Claude10a 11m 26j5H1310-06-20124T
62AE27-099/2012 MAE27-099/2012 MAE27-099/2012 MGérard Claude10a 11m 26j5H1310-06-20124T
63AEY27-038/2023 MAEY27-038/2023 MAEY27-038/2023 MGérard Claude0a 0m 15j5H521-05-20234T
64AEY27-039/2023 FAEY27-039/2023 FAEY27-039/2023 FGérard Claude0a 0m 14j4B622-05-20234T
65AEY27-040/2023 FAEY27-040/2023 FAEY27-040/2023 FGérard Claude0a 0m 14j4B622-05-20234T
66AEY27-041/2023 MAEY27-041/2023 MAEY27-041/2023 MGérard Claude0a 0m 14j5H622-05-20234T
67AEY27-042/2023 FAEY27-042/2023 FAEY27-042/2023 FGérard Claude0a 0m 13j4B1323-05-20234T
68AEY27-043/2023 MAEY27-043/2023 MAEY27-043/2023 MGérard Claude0a 0m 13j5H1323-05-20234T
69AEY27-044/2023 MAEY27-044/2023 MAEY27-044/2023 MGérard Claude0a 0m 13j5H1323-05-20234T
70AEY27-045/2023 FAEY27-045/2023 FAEY27-045/2023 FGérard Claude0a 0m 11j4B725-05-20234T
71AEY27-046/2023 FAEY27-046/2023 FAEY27-046/2023 FGérard Claude0a 1m 11j4B1525-04-20234T
72AEY27-047/2023 MAEY27-047/2023 MAEY27-047/2023 MGérard Claude0a 1m 3j5H111-05-20234T
73AEY27-048/2023 FAEY27-048/2023 FAEY27-048/2023 FGérard Claude4a 1m 14j4B1122-04-20195T
74AEY27-049/2023 MAEY27-049/2023 MAEY27-049/2023 MGérard Claude4a 1m 14j5H1122-04-20195T
75AEY27-050/2023 MAEY27-050/2023 MAEY27-050/2023 MGérard Claude4a 1m 14j5H1122-04-20195T
76AEY27-051/2023 FAEY27-051/2023 FAEY27-051/2023 FGérard Claude4a 1m 14j4B1122-04-20195T
77AEY27-052/2023 FAEY27-052/2023 FAEY27-052/2023 FGérard Claude4a 1m 14j4B122-04-20194T
78AEY27-053/2023 FAEY27-053/2023 FAEY27-053/2023 FGérard Claude4a 1m 16j4B220-04-20194T
79AEY27-054/2023 FAEY27-054/2023 FAEY27-054/2023 FGérard Claude0a 0m 15j4B521-05-20234T
80AEY27-055/2023 MAEY27-055/2023 MAEY27-055/2023 MGérard Claude0a 0m 15j5H521-05-20234T
81AEY27-056/2023 MAEY27-056/2023 MAEY27-056/2023 MGérard Claude0a 0m 15j5H521-05-20234T
82AEY27-057/2023 MAEY27-057/2023 MAEY27-057/2023 MGérard Claude0a 0m 15j5H521-05-20234T
83AEY27-058/2023 MAEY27-058/2023 MAEY27-058/2023 MGérard Claude0a 1m 3j5H111-05-20234T
84AEY27-059/2023 FAEY27-059/2023 FAEY27-059/2023 FGérard Claude0a 0m 31j4B125-05-20234T
85AEY27-060/2023 MAEY27-060/2023 MAEY27-060/2023 MGérard Claude0a 0m 15j5H521-05-20234T
86AEY27-061/2023 FAEY27-061/2023 FAEY27-061/2023 FGérard Claude0a 0m 15j4B521-05-20234T
87AEY27-062/2023 MAEY27-062/2023 MAEY27-062/2023 MGérard Claude0a 0m 15j5H521-05-20234T
88AEY27-063/2023 FAEY27-063/2023 FAEY27-063/2023 FGérard Claude0a 0m 15j4B521-05-20234T
89AEY27-064/2023 MAEY27-064/2023 MAEY27-064/2023 MGérard Claude0a 0m 15j5H521-05-20234T
90AEY27-065/2023 FAEY27-065/2023 FAEY27-065/2023 FGérard Claude0a 0m 14j4B622-05-20234T
91AEY27-066/2023 FAEY27-066/2023 FAEY27-066/2023 FGérard Claude0a 0m 13j4B1323-05-20234T
92AEY27-067/2023 FAEY27-067/2023 FAEY27-067/2023 FGérard Claude0a 0m 13j4B1323-05-20234T
93AEY27-068/2023 MAEY27-068/2023 MAEY27-068/2023 MGérard Claude0a 0m 13j5H1323-05-20234T
94AEY27-069/2023 FAEY27-069/2023 FAEY27-069/2023 FGérard Claude0a 0m 11j4B725-05-20234T
Parents
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
How about
VBA Code:
Sub harzer()
   With Range("A2:C" & Range("C" & Rows.Count).End(xlUp).Row)
      .Value = Evaluate(Replace("if(@="""","""",replace(@,len(@),0,"" ""))", "@", .Address))
   End With
End Sub
 
Upvote 0
Hello fluff,
Thank you for your proposal, it meets my expectations and fully satisfies me.
Kudos for the efficiency.
Thank you so much.
Cheers.
 
Upvote 0
You're welcome & thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,223,896
Messages
6,175,260
Members
452,627
Latest member
KitkatToby

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top