put ^ between number and text EG- 125663232 5555 ^ good day

[shrinivasmj]

hi

i need a formula to put ^ in between no and text

put ^ between number and text 125663232 5555 ^ good day


456845563 ^ WE ARE HAPPRY
7896846511 ^ HELP YOU

 

[123rickfear]

=a1&"^"&b1

or is your data in one cell i.e 123hello to be 123^hello

 

[shrinivasmj]

Data is in one cell

 

[123rickfear]

=left(a1,min(find({0,1,2,3,4,5,6,7,8,9},a1&"0123456789"))-1)&"^"&right(a1,min(find({0,1,2,3,4,5,6,7,8,9},a1&"0123456789"))-1)

 

[shrinivasmj]

the out put is coming only ^

 

[123rickfear]

have you changed the a1's to the cell that your data is in?

 

[bosco_yip]

Try this :

=REPLACE(A1,LOOKUP(1,-MID(A1,ROW($1:$99),1),ROW($1:$99))+1,1," ^ ")

 

[shrinivasmj]

Thanks a lot bro

 

[shrinivasmj]

need help

if i have data like

[h=2]125663232 5555 good day 7898797987[/h]
it as to put like this [h=2]125663232 5555 ^ good day 7898797987[/h]