muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,105
- Office Version
- 365
- 2021
- Platform
- Windows
hi all.
how to extract data from single cell (merged cell) like this:
thanks in advance,
how to extract data from single cell (merged cell) like this:
Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | data | extract | |||||
2 | Mr XXX 198505162008121003 New York, 16-05-1985 | Mr XXX | 198505162008121003 | New York | 16/05/1985 | ||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | Mrs. YYYY 197404231996021001 Hongkong, 23-04-1974 | Mrs. YYYY | 197404231996021001 | Hongkong | 23/04/1974 | ||
8 | |||||||
9 | |||||||
10 | |||||||
11 | |||||||
12 | Mr ZZZZZZZZZ 198301282009012003 France, 28-01-1983 | etc…... | |||||
13 | |||||||
14 | |||||||
Sheet1 |
thanks in advance,