How to add unit after comma ?
My cells are like
A2: Apple | B2: 1, 2, 3, 4, X, Y
A100: ..... | B100: ..............
Output
A2: Apple KG | B2: 1 KG, 2 KG, 3 KG, 4 KG, X KG, Y KG
A100: ..... | B100: ..............
How to add unit after comma ?
My cells are like
A2: Apple | B2: 1, 2, 3, 4, X, Y
A100: ..... | B100: ..............
Output
A2: Apple KG | B2: 1 KG, 2 KG, 3 KG, 4 KG, X KG, Y KG
A100: ..... | B100: ..............
There's a better way to post an example, you know.... But you can use "Find and Replace" Find what:, Replace with:KG,
Find & replace?
Entia non sunt multiplicanda sine necessitate
Find & replace?
Yes, Find and Replace.
CTRL + H
find
replace by
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks