remove space between text or no from left count

[shrinivasmj]

i have a data in cell a1 need to remove space by count lenth and remove the space

321321 23132 2 2 2 1 2 is the right time to talk

3213212313222212 is the right time to talk out put


latter 16 from left and remove space in between

 

[Rick Rothstein]

i have a data in cell a1 need to remove space by count lenth and remove the space

321321 23132 2 2 2 1 2 is the right time to talk

3213212313222212 is the right time to talk out put

latter 16 from left and remove space in between

One example is not usually enough to base a pattern on, but this works for what you posted...

=LEFT(SUBSTITUTE(A1," ",""),16)&MID(A1,FIND(" "&MID(SUBSTITUTE(A1," ",""),17,1),A1),LEN(A1))