Ask Your Question

How to add space between a certain text [closed]

asked 2021-01-05 16:06:00 +0100

Jefri gravatar image

I have a certain text "G2G", "G43G", "G576G"..etc. How can I add spaces using Find and Replace so that it would be "G 2 G", "G 43 G", "G 576 G" and so on

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Jefri
close date 2021-01-05 18:21:54.040236


Please tell explicitly what is allowed in the place of "G". Is it exactly this letter (in upper case)? Any letter? Case sensitive? What else probably?.
What is allowed between the two poles? One up to three decimal digits,? Any number of dgits? Numbers with a sign (+/-) too? Any number like 5.678 also? Or even -1.602E-19 ? Also with ...

A few examples cannot tell enough for sure. In specific you cannot exclude something by examples.

Lupp gravatar imageLupp ( 2021-01-05 17:33:00 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2021-01-05 17:02:39 +0100

dscheikey gravatar image

Hi Jefri,

in Find and Replace: Search (\w)(\d+)(\w) Replace $1 $2 $3 Regex: on

or as a Formula: =REGEX(A1,"(\w)(\d+)(\w)","$1 $2 $3","g") when your text is in cell A1.

I hope this helps. :-)

Please mark this question as answered.

edit flag offensive delete link more


TQVM..this is exactly what I need

Jefri gravatar imageJefri ( 2021-01-05 18:16:22 +0100 )edit

answered 2021-01-05 17:04:32 +0100

PKG gravatar image

image description

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2021-01-05 16:06:00 +0100

Seen: 32 times

Last updated: Jan 05