How to remove the space inbetween numbers

[uday1969]

A b c d
4 3 1* * 8 2 6 * * 6 6 1 * * 228
4 4 1* * 8 5 3 * * 3 9 8 * * 4 9 4 * *
1 2 5* * 5 0 7 * * 7 2 3 * * 1 4 9 * *
1 8 1* * 7 7 3 * * 9 8 3 * * 0 1 0 * *

I have column A, B, C and D.... How to remove space of A, B, C D of numbers

[FlameRetired]

Try

=SUBSTITUTE(A1," ","")

Fill across and down.

[David A Coop]

I can't tell whether the spaces are embedded (that is in a column, you have number space number), or they are leading or trailing spaces.

@FlameRetired suggested SUBSTITUTE.

I think this will give you text.

If you want to have a number, you could use =VALUE(A1) which will ignore the leading or trailing spaces. It won't work with embedded spaces.
You would need to combine the two thus: =VALUE(SUBSTITUTE(A1," ",""))

I hope this helps, please let me know!

Regards,

David

If this has been helpful
- Please click on the *Add Reputation button at the bottom left.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

[deciog]

Uday1969

Use this TRIM function

=TRIM(A1)

Decio

[xladept]

Like deciog says - the WorksheetFunction Trim will remove internal spaces but the VBA Trim will not

[FlameRetired]

A b c d
4 3 1* * 8 2 6 * * 6 6 1 * * 228
4 4 1* * 8 5 3 * * 3 9 8 * * 4 9 4 * *
1 2 5* * 5 0 7 * * 7 2 3 * * 1 4 9 * *
1 8 1* * 7 7 3 * * 9 8 3 * * 0 1 0 * *

I have column A, B, C and D.... How to remove space of A, B, C D of numbers

uday1969 the more I look at this the more I wonder. What do the "*" characters represent in the example? Are they spaces or literal "*"s?

Can you also post the desired output ... indicating if they are to be text (including or excluding "*"s) or numbers as David A Coop pointed out?

[RDA Di]

Please help, Need to remove space between numbers within a long text

For example:

POUCH, STERILIZATION, 3.5X4 4IN, SELF-SEALING, BLUE, TENTED TRANSPARENT FILM, EASY DETECTION, EXTERNAL AND INTERNAL INDICATOR, MULTIPLE SEAL, 10 00POUCHES/BOX

Desired Output

POUCH, STERILIZATION, 3.5X44IN, SELF-SEALING, BLUE, TENTED TRANSPARENT FILM, EASY DETECTION, EXTERNAL AND INTERNAL INDICATOR, MULTIPLE SEAL, 1000POUCHES/BOX

[AliGW]

You are pushing your luck now. You already have your own thread on this.